Re: date time function

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