undocumented date addition/subtraction operators

Started by Tom Laneover 22 years ago1 messagesdocs
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

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@meerkatsoft.com>
To: pgsql-general@postgresql.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