SQL Server‎ > ‎

How to convert a date/time to midnight

Use the following syntax in a SQL query - convert(datetime,convert(varchar(10),[tablename.fieldname]),112))
Comments