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