date function in ingres

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

malti - 23 Jun 2004 21:50 GMT

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

Reply to this Message

Christian Maslen - 24 Jun 2004 23:25 GMT

Hi Malti,

> 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.

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.

Reply to this Message