Received: from spider.pilosoft.com (p55-222.acedsl.com [160.79.55.222]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f63CwEa50391 for ; Tue, 3 Jul 2001 08:58:15 -0400 (EDT) (envelope-from alex@pilosoft.com) Received: from localhost (alexmail@localhost) by spider.pilosoft.com (8.9.3/8.9.3) with ESMTP id JAA26259; Tue, 3 Jul 2001 09:08:48 -0400 (EDT) Date: Tue, 3 Jul 2001 09:08:48 -0400 (EDT) From: Alex Pilosov To: datactrl cc: pgsql-sql@postgresql.org Subject: Re: problem with date/time constants In-Reply-To: <006101c103bd$f01206a0$2400a8c0@hnjack> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200107/15 X-Sequence-Number: 3796 You must either do: select now(); or select 'now'::timestamp; now() is a function that takes no arguments. it is also a special value recognized by timestamp parser. On Tue, 3 Jul 2001, datactrl wrote: > Hi, > server:PostgreSQl 7.1 > why doesn't following statement work? > "select now;" > > THANK YOU! > JACK LIU > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > >