>>>Hi,
>>>
>>>I am working with the SQL Server database. The field/column is DateTime. And I want to get records by the following criteria:
>>>
>>>

>>>select * from MyTable where DateTimeCol <= '20170810'  
>>>

>>>
>>>Since the DateTimeCol has both the date and time, the above will select 0 records.
>>>
>>>How should I change the WHERE to make sure that only the Date of DateTime is considered and therefore the records where the Date is '20170810' are returned?
>>
>>Simply:
>>
>>

>>select * from MyTable where DateTimeCol < '20170811'  
>>

>
>Thank you, Cetin. It is just that my existing code already uses the Less Than or Equal (not Less Than) and the approach suggested by Martina (cast DateTimeCol as date) works perfectly.


From my POV, changing code from LTE to LT is easier than converting it to use a cast() statement and it is portable, version independent, doesn't have the unneccassry conversion overhead etc. Anyway it is your code.