undocumented date addition/subtraction operators

Поиск
Список
Период
Сортировка
От Tom Lane
Тема undocumented date addition/subtraction operators
Дата
Msg-id 21197.1062084994@sss.pgh.pa.us
обсуждение исходный текст
Список 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@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


В списке pgsql-docs по дате отправления:

Предыдущее
От: "Chris M"
Дата:
Сообщение: Re: Changing the sequence owner
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Automatic documentation spell check