Ashok Agrawal wrote:
> 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.
Umm, SELECT CURRENT_DATE - creation_date FROM my_table;
-- Richard Huxton Archonet Ltd
