Re: Date / interval question

From: Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com>
To: "kevin kempter" <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Date / interval question
Date: 2008-04-11 12:43:38
Message-ID: a55915760804110543k49c96c83ib48ac78500ce2064@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 10, 2008 at 10:26 PM, kevin kempter
<kevin(at)kevinkempterllc(dot)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')));

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Obe, Regina 2008-04-11 12:48:36 Operator COMMUTATOR - how does postgresql use this information
Previous Message J Ottery 2008-04-11 12:02:21 Re: Postgres on shared network drive