Using SQL, how can I convert a data in a datetime field to a date only data?
When I run a job to collect data, I use the getdate() function that returns the date and time. I want to then convert this to the same date but with a time of 00:00:00. Please advise.
March 14, 2008 3:36 PM
September 10, 2013 2:34 PM