Received: from bleys.tpgi.com.au (bleys.tpgi.com.au [203.12.160.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f63Ckla45425 for ; Tue, 3 Jul 2001 08:46:47 -0400 (EDT) (envelope-from quals@bigfoot.com) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f63Ckfw24560 for ; Tue, 3 Jul 2001 22:46:42 +1000 Received: from bri2-56k-250.tpgi.com.au(203.29.144.250), claiming to be "hnjack" via SMTP by bleys.tpgi.com.au, id smtpdaopVtc; Tue Jul 3 22:46:34 2001 Message-ID: <006101c103bd$f01206a0$2400a8c0@hnjack> From: "datactrl" To: Subject: problem with date/time constants Date: Tue, 3 Jul 2001 22:44:44 +1000 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 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200107/14 X-Sequence-Number: 3795 Hi, server:PostgreSQl 7.1 why doesn't following statement work? "select now;" THANK YOU! JACK LIU