this one's simpler

Eric J McKeown <ericm@palaver.net>

From: Eric McKeown <ericm@palaver.net>
To: PGsql <pgsql-sql@postgreSQL.org>
Date: 1998-08-25T00:06:45Z
Lists: 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