Обсуждение: undocumented date addition/subtraction operators

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

undocumented date addition/subtraction operators

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