> 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
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
************