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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.