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