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

Re: DISTINCT ON troubles

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Brian Knox <laotse(at)aol(dot)net>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: DISTINCT ON troubles
Date: 2004-02-19 21:51:26
Message-ID: Pine.LNX.4.33.0402191451120.7643-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Thu, 19 Feb 2004, scott.marlowe wrote:

> On Thu, 19 Feb 2004, Brian Knox wrote:
> 
> > ( sorry if this is a repeat, my mail server is being wonky today )
> > 
> > I'm looking for a way, within SQL, given a starting date and an ending 
> > date, to get back the number of months between the start and end date. 
> > If I "SELECT end_date - start_date", I get back an interval in days; I 
> > need months.
> 
> Maybe date_part?
> 
> select date_part('month','2004-08-02 12:00:00'::timestamp) - 
> date_part('month','2004-05-01 12:00:00'::timestamp);

Note that I think you need a +1 at the end of that...


In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-02-19 22:38:06
Subject: Re: Distributed Transactions
Previous:From: scott.marloweDate: 2004-02-19 21:39:52
Subject: Re: DISTINCT ON troubles

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