>>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'  
>

Similar to what I was doing a dozen years ago:

select * from MyTable where DateTimeCol <= '20170810 23:59:59'