<div>
The index friendly way is to use this approach:<br />

<pre><code id="code-20-42007195-1">WHERE  Column &gt;= {startDateAtMidnight}
AND       Column &lt; {nextDayAtMidnight}</code></pre>
<br />
.. in other words:<br />
<br />

<pre><code id="code-20-42007195-2">WHERE DATE_ORDER &gt;= CAST(GETDATE()AS DATE)
AND      DATE_ORDER &lt; CAST(DateAdd(d, 1, GETDATE()) AS DATE)</code></pre>
</div>


The index friendly way is to use this approach:


WHERE  Column >= {startDateAtMidnight}
AND       Column < {nextDayAtMidnight}


.. in other words:



WHERE DATE_ORDER >= CAST(GETDATE()AS DATE)
AND      DATE_ORDER < CAST(DateAdd(d, 1, GETDATE()) AS DATE)

<div>
ID: 42007195<br />
<br />
How would it be? is it right this way?<br />
<br />

<pre><code id="code-20-42007244-1">  Where CAST(DATE_ORDER AS DATE) &gt;=  cast('20170105' as date) and CAST(DATE_ORDER AS DATE) &lt;= cast('20170210' as date)</code></pre>
</div>


ID: 42007195

How would it be? is it right this way?



  Where CAST(DATE_ORDER AS DATE) >=  cast('20170105' as date) and CAST(DATE_ORDER AS DATE) <= cast('20170210' as date)

<div>
<div class="content wysiwyg-content">
Hello guys, <br />
<br />
I am working In a company where there are many queries made with this kind of date filter<br />
<br />
SELECT * FROM TABLE<br />
WHERE CONVERT(VARCHAR(10), &nbsp;DATE_ORDER, 112) = CONVERT(VARCHAR(10), GETDATE(), 112)<br />
<br />
I am in douts that this is a bad practice, even if I have the field DATE_ORDER indexed, when the filter <br />
is made that way, the index is put aside.<br />
<br />
What is the better way to work with date fields and filters?<br />
<br />
thanks <br />
Alexandre
</div>
</div>


Hello guys, 

I am working In a company where there are many queries made with this kind of date filter

SELECT * FROM TABLE
WHERE CONVERT(VARCHAR(10),  DATE_ORDER, 112) = CONVERT(VARCHAR(10), GETDATE(), 112)

I am in douts that this is a bad practice, even if I have the field DATE_ORDER indexed, when the filter 
is made that way, the index is put aside.

What is the better way to work with date fields and filters?

thanks 
Alexandre

Better way to make a query with date filter.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.