Link to home
Start Free TrialLog in
Avatar of tlpacheco
tlpacheco

asked on

cast in sql

hlo
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
Thierry
ASKER CERTIFIED SOLUTION
Avatar of Trekker72
Trekker72

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial