This is useful when you want to group records by date but your datetime column has a time value also. This code converts your date to a varchar in a specified format.
--101 is "mm/dd/yyyy"
SELECT CONVERT(varchar,DateField,101)
-- 1 is "mm//dd/yy"
SELECT CONVERT(varchar,DateField,1)
-- 108 is "hh:mm:ss"
-- An example query
Select
CallDateTime
Remember Me