Re: DISTINCT ON troubles

From: Brian Knox <laotse(at)aol(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: DISTINCT ON troubles
Date: 2004-02-19 21:06:09
Message-ID: 40352541.8040507@aol.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

( 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.

Thanks for any suggestions,
Brian

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message scott.marlowe 2004-02-19 21:39:52 Re: DISTINCT ON troubles
Previous Message Gnugeek 2004-02-19 21:04:22 Re: Date / interval question