i want to make a request sql will return distinct date in a table.
The date are the attribut 'dat_achat' in my table 'facture'
the type is timestanp and where i 'm execute the request :
select distinct f.dat_achet from facture
all the date are selectionned because the time are different
I would like execute a request that like :
select cast(f.dat_achat to date) from facture f
but it don't work
tks for help