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

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Johny Jugianto <johny(dot)q(at)rocketmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [OOT] timestamp / time ('now') in postgresql 7.2?
Date: 2002-03-21 14:29:39
Message-ID: 20020321222743.V96955-100000@houston.familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Vincent Stoessel 2002-03-21 14:40:42 Re: Migrating a MySQL schema with an enum
Previous Message Johny Jugianto 2002-03-21 11:46:50 [OOT] timestamp / time ('now') in postgresql 7.2?