Code: SQL
SELECT DISTINCT CONVERT(char,myDate,1) FROM myDataTable