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 B7A79D1B4E1 for ; Fri, 19 Sep 2003 15:59:50 +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 78339-01 for ; Fri, 19 Sep 2003 12:59:20 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id A76EBD1B4EB for ; Fri, 19 Sep 2003 12:59:19 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 3BAA83533A; Fri, 19 Sep 2003 08:59:19 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 3A3EC35339; Fri, 19 Sep 2003 08:59:19 -0700 (PDT) Date: Fri, 19 Sep 2003 08:59:19 -0700 (PDT) From: Stephan Szabo To: Kumar Cc: psql Subject: Re: Problem with timestamp - Pls help In-Reply-To: <20030919083808.K212@megazone.bigpanda.com> Message-ID: <20030919085901.F1519@megazone.bigpanda.com> References: <038501c37eaf$ff68a310$7502a8c0@hdsc.com> <20030919083808.K212@megazone.bigpanda.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/205 X-Sequence-Number: 15183 On Fri, 19 Sep 2003, Stephan Szabo wrote: > 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) I meant (2) above.