Horton

Re: [OOT] timestamp / time ('now') in postgresql 7.2?

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread View on postgr.es
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Johny Jugianto <johny.q@rocketmail.com>
Cc: pgsql-sql@postgresql.org
Date: 2002-03-21T14:29:39Z
Lists: pgsql-sql 
> i'm have installed latest version of postgresql which is 7.2
> why i can not use timestamp('now') or time('now') ?
> it said : ERROR:    parser: parse error at or near "'"

Those two words have become a little more reserved.  If you go
"timestamp"('now') or "time"('now') it should work.

Even better, I think you can go timestamp 'now' or time 'now' instead
IIRC.

Chris