<div>
Convert in WHERE clause is big bad so, you may wish to do something as follows:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42096453-1"><span>declare @today [datetime] = convert([datetime], convert([date], getDate()))</span>
<span></span>
<span>where [due_on] = @today</span>
</code></pre>
</div>


<div>
Thanks. I updated my query accordingly. &nbsp;out of curiosity why is it a bad ?
</div>


<div>
First it happens for each row in the table &quot;on the fly&quot; which has performance implications.<br />
<br />
Second, if you have an index on column due_on, it will not be used if either side of equation is using ANY function in WHERE clause and convert is a function.<br />
<br />
Depending on number of rows in your table, you may wish to have a index on that column.<br />
<br />
In addition, the convert on getdate() will always return the identical value, so no point calling n number of times where n is number of rows in table.
</div>


<div>
Purely as an FYI:<br />
<br />
WHERE convert([date], due_on) = CONVERT([Date], GETDATE())<br />
<br />
This would occur on every row:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; convert([date], due_on) <br />
<br />
<i>and it is not necessary</i><br />
<br />
<br />
This does <u>not</u> occur on every row<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CONVERT([Date], GETDATE())<br />
<br />
(The optimizer know it only needs to perform this once.)
</div>


<div>
Yes, forgot that. Just as Where 1 = 1 is ignored. Thank you!
</div>


<div>
<div class="content wysiwyg-content">
I am trying to select reminders for 'today'<br />
the date is saved in a datetime field, and is for example: <br />
<br />
2017-04-18 00:00:00.000<br />
<br />
I am trying the following but I get no results. I imagine its because it is taking the time into account. How can I compare the date only?<br />
<br />
&nbsp;
<pre><code class="code-1 nolinks" id="code-10-29016772-1"><span>WHERE due_on= GETDATE()</span>
</code></pre>
</div>
</div>


I am trying to select reminders for 'today'
the date is saved in a datetime field, and is for example: 

2017-04-18 00:00:00.000

I am trying the following but I get no results. I imagine its because it is taking the time into account. How can I compare the date only?

 (CODE)

compare date to getdate()

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.