select distinct cast(DATE as date) from myschema.mytable GROUP BY DATE