Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-docs by date

Next:From: Peter EisentrautDate: 2003-08-28 17:15:21
Subject: Re: Automatic documentation spell check
Previous:From: Tom LaneDate: 2003-08-28 03:11:26
Subject: Re: Automatic documentation spell check

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group