this one's simpler

From: Eric McKeown <ericm(at)palaver(dot)net>
To: PGsql <pgsql-sql(at)postgreSQL(dot)org>
Subject: this one's simpler
Date: 1998-08-25 00:06:45
Message-ID: Pine.LNX.3.96.980824190428.563A-100000@farout.palaver.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)palaver(dot)net
http://www.palaver.net

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Cho Yan Wong 1998-08-25 02:17:45 copy probs
Previous Message Eric McKeown 1998-08-24 23:33:53 parts of date_part()