undocumented date addition/subtraction operators

Поиск
Список
Период
Сортировка
Искать

undocumented date addition/subtraction operators

От:
Tom 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 
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

FAQ