Received: from tarantula.com (unknown [202.153.249.155]) by postgresql.org (Postfix) with SMTP id C9BC747599D for ; Thu, 21 Mar 2002 06:47:09 -0500 (EST) Received: (qmail 3941 invoked from network); 21 Mar 2002 11:48:44 -0000 Received: from unknown (HELO enterprise) (192.0.0.5) by 192.0.0.1 with SMTP; 21 Mar 2002 11:48:44 -0000 Message-ID: <000a01c1d0ce$178929b0$050000c0@enterprise> From: "Johny Jugianto" To: References: <3C991E29.C90559F4@heart.com.au> <20020321113145.E84DBFA1D@bugs.unl.edu.ar> Subject: [OOT] timestamp / time ('now') in postgresql 7.2? Date: Thu, 21 Mar 2002 18:46:50 +0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200203/276 X-Sequence-Number: 7155 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