undocumented date addition/subtraction operators

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-docs(at)postgreSQL(dot)org
Subject: undocumented date addition/subtraction operators
Date: 2003-08-28 15:36:34
Message-ID: 21197.1062084994@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

I just realized why the attached and variants are FAQs --- the operators
for date minus date, date plus integer, etc are documented nowhere.

Will fix.

regards, tom lane

------- Forwarded Message

Date: Thu, 28 Aug 2003 23:09:44 +0900
From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Date Time Function / Age

Hi,
is there an easy way to get the Difference between 2 dates in Days... as
an integer?

age('date1','date2') results in x years y days or something similar.
but I would like to
have the result in number of days as an integer.

Thanks for your help

Alex

------- End of Forwarded Message

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2003-08-28 17:15:21 Re: Automatic documentation spell check
Previous Message Tom Lane 2003-08-28 03:11:26 Re: Automatic documentation spell check