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