Re: Date Time Function / Age - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Date Time Function / Age
Date
Msg-id 20030829030750.GA5204@wolff.to
Whole thread Raw
In response to Date Time Function / Age  (Alex <alex@meerkatsoft.com>)
List pgsql-general
On Thu, Aug 28, 2003 at 23:09:44 +0900,
  Alex <alex@meerkatsoft.com> wrote:
> 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.

If you subtract two dates (not timestamps) you will get an integer that is
the number of days difference in the dates.

pgsql-general by date:

Previous
From: Ursula Lee
Date:
Subject: Unsubscribe from the list
Next
From: expect
Date:
Subject: Re: How does it work