<div>
You could always just use the month number:<br />
<br />

<pre><code id="code-20-39959550-1">where month(entrytime) = 1</code></pre>
<br />
Neither option of course, takes the year into account.
</div>


You could always just use the month number:



where month(entrytime) = 1


Neither option of course, takes the year into account.

<div>
<div class="content wysiwyg-content">
select frmRegistrationCSWText1, count(Distinct ID) from frmRegistrationCSW where entrytime = 'january' group by frmRegistrationCSWText1<br />
<br />
I get the following error after running the above code:<br />
Msg 241, Level 16, State 1, Line 1<br />
Conversion failed when converting date and/or time from character string.<br />
<br />
How do I specifiy entrytime correctly. &nbsp;datatype is datetime for that entrytime
</div>
</div>


select frmRegistrationCSWText1, count(Distinct ID) from frmRegistrationCSW where entrytime = 'january' group by frmRegistrationCSWText1

I get the following error after running the above code:
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.

How do I specifiy entrytime correctly.  datatype is datetime for that entrytime

error on query datetime by month

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.