Re: [GENERAL] Question on timestamp in psql

> When I type the following at the psql prompt:
>
> select timestamp('now');
>
> ...I always get december 31, 1999.
>
> If I use 'now' as the rvalue to a SET, or within an INSERT, it returns
> the correct date.
>
> Is this a known problem? I'm running 6.5.2-1.

Yikes, confirmed in current sources:

test=> select timestamp('now');
timestamp
------------------------
1999-12-31 19:00:00-05
(1 row)

This works:

test=> select timestamp('now'::timestamp);
timestamp
------------------------
2000-01-11 11:28:08-05
(1 row)

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026