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