Received: from mailin6.bigpond.com (juicer03.bigpond.com [139.134.6.79]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f63D30a52928 for ; Tue, 3 Jul 2001 09:03:00 -0400 (EDT) (envelope-from david@netventures.com.au) Received: from runt.in.netventures.com.au ([144.135.24.69]) by mailin6.bigpond.com (Netscape Messaging Server 4.15) with SMTP id GFWF6F00.2CK; Tue, 3 Jul 2001 23:08:39 +1000 Received: from KTPP-p-203-54-3-82.prem.tmns.net.au ([203.54.3.82]) by bwmam01.mailsvc.email.bigpond.com(MailRouter V2.9g 8311/5468161); 03 Jul 2001 23:08:38 Received: from ciderbox.in.netventures.com.au ([192.168.10.19] helo=localhost) by runt.in.netventures.com.au with esmtp (Exim 3.03 #1 (Debian)) id 15HQI9-0004pM-00; Tue, 03 Jul 2001 23:32:37 +1000 Date: Tue, 3 Jul 2001 23:03:42 +1000 From: David Stanaway Content-Type: text/plain; format=flowed; charset=us-ascii Subject: Re: problem with date/time constants Cc: quals@bigfoot.com To: X-Mailer: Apple Mail (2.388) In-Reply-To: <006101c103bd$f01206a0$2400a8c0@hnjack> Mime-Version: 1.0 (Apple Message framework v388) Content-Transfer-Encoding: 7bit Message-Id: X-Archive-Number: 200107/16 X-Sequence-Number: 3797 On Tuesday, July 3, 2001, at 10:44 PM, datactrl wrote: > Hi, > server:PostgreSQl 7.1 > why doesn't following statement work? > "select now;" Tried rtfm? :P How about: SELECT CURRENT_TIMESTAMP as now; -- Best Regards David Stanaway ========================.--------------------------------------------- Technology Manager - Australia's Premier Internet Broadcasters david@NetVentures.com.au Office +612 9357 1699 ========================'---------------------------------------------