Re: now() AT TIME ZONE interval '-5 hours' returns type interval???

On Thursday 13 March 2003 8:10 pm, Tom Lane wrote:
> UPDATE pg_proc SET prorettype = 1114 WHERE prosrc = 'timestamptz_izone';

This syntax looked useful to me so I tried the update you suggested
(fortunately on an old test system running 7.2.3) and now it only returns
2000-01-01 00:00:00. Always.

steve=# select now() at time zone interval '6 hours';
      timezone
---------------------
 2000-01-01 00:00:00
(1 row)

steve=# select now() at time zone interval '-5 hours';
      timezone
---------------------
 2000-01-01 00:00:00
(1 row)

steve=# select now() at time zone interval '4.5 hours';
      timezone
---------------------
 2000-01-01 00:00:00
(1 row)

steve=# select now() at time zone interval '0';
      timezone
---------------------
 2000-01-01 00:00:00
(1 row)

Cheers,
Steve