On Jun 28, 2007, at 15:13 , Raymond O'Donnell wrote:
Cast your result to type INTERVAL - something like this:
postgres=# select (current_timestamp - timestamp
'2007-05-01')::interval;
interval
----------------------
58 days 21:10:36.748
(1 row)
The cast to interval is superfluous: timestamp - timestamp already
gives you an interval result. Also, Postgres will interpret
'2007-05-01' as a date in this context:
# select current_timestamp - '2007-05-01';
?column?
-------------------------
58 days 16:25:53.776695
(1 row)
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
