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 ADD3BD1B4E3 for ; Fri, 19 Sep 2003 15:40:32 +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 72955-08 for ; Fri, 19 Sep 2003 12:40:00 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 925AAD1B514 for ; Fri, 19 Sep 2003 12:40:00 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id D398C352CD; Fri, 19 Sep 2003 08:39:59 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id D241C35277; Fri, 19 Sep 2003 08:39:59 -0700 (PDT) Date: Fri, 19 Sep 2003 08:39:59 -0700 (PDT) From: Stephan Szabo To: Kumar Cc: psql Subject: Re: Problem with timestamp - Pls help In-Reply-To: <038501c37eaf$ff68a310$7502a8c0@hdsc.com> Message-ID: <20030919083808.K212@megazone.bigpanda.com> References: <038501c37eaf$ff68a310$7502a8c0@hdsc.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/202 X-Sequence-Number: 15180 On Fri, 19 Sep 2003, Kumar wrote: > Dear Friends, > > I am using Postgres 7.3.4 on Linux server 7.3. > > I wanted to update one column of my table with now() or timestamp. And I want that timestamp of format ------------------------ > 2003-09-19 18:39:08.13 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.