X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 76A32D1B523 for ; Fri, 19 Sep 2003 16:27:39 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 86354-08 for ; Fri, 19 Sep 2003 13:27:29 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 84890D1B503 for ; Fri, 19 Sep 2003 13:27:28 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h8JGRRiP021871; Fri, 19 Sep 2003 12:27:27 -0400 (EDT) To: Stephan Szabo Cc: Kumar , psql Subject: Re: Problem with timestamp - Pls help In-reply-to: <20030919083808.K212@megazone.bigpanda.com> References: <038501c37eaf$ff68a310$7502a8c0@hdsc.com> <20030919083808.K212@megazone.bigpanda.com> Comments: In-reply-to Stephan Szabo message dated "Fri, 19 Sep 2003 08:39:59 -0700" Date: Fri, 19 Sep 2003 12:27:26 -0400 Message-ID: <21870.1063988846@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/206 X-Sequence-Number: 15184 Stephan Szabo writes: > I think select CAST(CURRENT_TIMESTAMP(0) AS timestamp without time zone) > may get you what you want without having to rely on the text format. If you don't want the time zone, there's also LOCALTIMESTAMP(n). See http://www.postgresql.org/docs/7.3/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT regards, tom lane