Postgres Pro
Downloads
Home   >   mailing lists

Re: Date / interval question - Mailing list pgsql-general

From Rodrigo E. De León Plicet
Subject Re: Date / interval question
Date
Msg-id a55915760804110543k49c96c83ib48ac78500ce2064@mail.gmail.com
Whole thread Raw
In response to Date / interval question  (kevin kempter <kevin@kevinkempterllc.com>)
List pgsql-general
Tree view 
On Thu, Apr 10, 2008 at 10:26 PM, kevin kempter
<kevin@kevinkempterllc.com> wrote:
>  However I'm stumped [er how to get the number of months from 09/01/2007
> thru 01/01/2007

select extract(month from (age(date '2007-1-1', date '2006-9-1')));

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: PostgresSQL on a networked drive with multiple users
Next
From: "Obe, Regina"
Date:
Subject: Operator COMMUTATOR - how does postgresql use this information