Help for this page

Select Code to Download


  1. or download this
    mydb=# select distinct cast(date as date) from myschema.mytable;
-[ RECORD 1 ]-----------
...
date        | 2019-09-20
-[ RECORD 3 ]-----------
date        | 2019-09-19
  2. or download this
    $sth_dates_uniq = $dbh->prepare("select distinct cast(date as date) fr
+om myschema.mytable;") or die;
$sth_dates_uniq->execute();
...
2019-09-19
2019-09-19
2019-09-19