Re: [SQL] date subtraction

2005-03-21 Thread Richard Huxton
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 - crea

[SQL] date subtraction

2005-03-20 Thread Ashok Agrawal
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 ---(end of