How to convert a date/time to midnight

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