I have date as yyyy-mm-dd HH-MM-SS in ingres database. I want to
select only yyyy-mm-dd and not the time. How do I do it? Please help.

Malti

Hi Malti,

You can use the date_trunc function. Eg:

select date('now') as date_with_time
,date_trunc('day',date('now')) as date_only

The doco can be found at:

http://esupport.ca.com/index.html

Christian.