SQL query where it can get data from a field where date is together with time based just on the date. 

select * from test 
where datediff(day, [datetimefield], '03/19/2014') = 0
Source
https://stackoverflow.com/questions/22506930/how-to-query-datetime-field-using-only-date-in-sql-server

Categorized in:

SQL,

Last Update: May 18, 2024