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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
