Re: [GENERAL] Question on timestamp in psql

2000-01-11 Thread Ed Loehr
Robert Rothe wrote: > When I type the following at the psql prompt: > > select timestamp('now'); Try select timestamp(now()); Cheers, Ed Loehr

Re: [GENERAL] Question on timestamp in psql

2000-01-11 Thread Bruce Momjian
> 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 sou

[GENERAL] Question on timestamp in psql

2000-01-11 Thread Robert Rothe
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. Thanks, Rob