this one's simpler - Mailing list pgsql-sql

From Eric McKeown
Subject this one's simpler
Date
Msg-id Pine.LNX.3.96.980824190428.563A-100000@farout.palaver.net
Whole thread Raw
Responses Re: [SQL] this one's simpler
List pgsql-sql
Ok, I think this questions is a little bit easier.  I have this piece of
code:

select (max(date_asked) - min(date_asked))::timespan from questions ;

And it produces this output:

timespan
------------------------------------
@ 2334 days 13 hours 21 mins 45 secs
(1 row)

Now, what I'd really like is a way to format that output into months so
that I could see the difference between the two dates in terms of months.
Pointers??

TIA...

eric

_______________________
Eric McKeown
ericm@palaver.net
http://www.palaver.net


pgsql-sql by date:

Previous
From: Eric McKeown
Date:
Subject: parts of date_part()
Next
From: Cho Yan Wong
Date:
Subject: copy probs