date subtraction

From: Ashok Agrawal <Ashok(dot)Agrawal(at)Sun(dot)COM>
To: pgsql-sql(at)postgresql(dot)org
Subject: date subtraction
Date: 2005-03-17 18:32:53
Message-ID: 4239CD55.305@Sun.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I need to do date calculation similar to oracle in postgres.

like sysdate - creation_date of the record which returns no
of days in oracle which you can convert to hours or second
by multiplying by 60 or 3600.

How do i achieve this in postgres.

Thanks
Ashok

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Leon Stringer 2005-03-17 20:21:24 Consecutive row count query
Previous Message Peter Eisentraut 2005-03-17 16:15:45 Re: lower and unicode