Postgres Pro
Downloads
Home   >   mailing lists

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

From Johny Jugianto
Subject [OOT] timestamp / time ('now') in postgresql 7.2?
Date
Msg-id 000a01c1d0ce$178929b0$050000c0@enterprise
Whole thread Raw
In response to Migrating a MySQL schema with an enum  (Keith Gray <keith@heart.com.au>)
Responses Re: [OOT] timestamp / time ('now') in postgresql 7.2?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-sql
Tree view 
hi

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 "'"

can anyone explain why?
i'm try in 7.1.x. it's works well
did i miss something when installation? is it in new version need somekind
of "plug-in"?

ps: date('now') is work fine

thx in advance

pgsql-sql by date:

Previous
From: Martín Marqués
Date:
Subject: Re: Migrating a MySQL schema with an enum
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [OOT] timestamp / time ('now') in postgresql 7.2?