mydb=# select distinct cast(date as date) from myschema.mytable;
-[ RECORD 1 ]-----------
date        | 2019-09-18
-[ RECORD 2 ]-----------
date        | 2019-09-20
-[ RECORD 3 ]-----------
date        | 2019-09-19