Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com [216.136.173.58]) by postgresql.org (8.11.3/8.11.1) with SMTP id f63DP3a63231 for ; Tue, 3 Jul 2001 09:25:03 -0400 (EDT) (envelope-from janwieck@yahoo.com) Received: from jupiter.us.greatbridge.com (65.196.69.55) by smtp.mail.vip.sc5.yahoo.com with SMTP; 3 Jul 2001 13:24:59 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f63DVQl18812; Tue, 3 Jul 2001 09:31:26 -0400 From: Jan Wieck Message-Id: <200107031331.f63DVQl18812@jupiter.us.greatbridge.com> Subject: Re: problem with date/time constants In-Reply-To: <006101c103bd$f01206a0$2400a8c0@hnjack> from datactrl at "Jul 3, 2001 10:44:44 pm" To: datactrl Date: Tue, 3 Jul 2001 09:31:25 -0400 (EDT) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/17 X-Sequence-Number: 3798 datactrl wrote: > Hi, > server:PostgreSQl 7.1 > why doesn't following statement work? > "select now;" Because it's not standard SQL and now is a function. Use either SELECT CURRENT_TIMESTAMP; which is standard (preferred) or SELECT now(); Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com