Postgres Pro
Downloads
Home   >   mailing lists

Re: [OOT] timestamp / time ('now') in postgresql 7.2? - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: [OOT] timestamp / time ('now') in postgresql 7.2?
Date
Msg-id 20020321222743.V96955-100000@houston.familyhealth.com.au
Whole thread Raw
In response to [OOT] timestamp / time ('now') in postgresql 7.2?  ("Johny Jugianto" <johny.q@rocketmail.com>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: "Johny Jugianto"
Date:
Subject: [OOT] timestamp / time ('now') in postgresql 7.2?
Next
From: Vincent Stoessel
Date:
Subject: Re: Migrating a MySQL schema with an enum