X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DB207D1B18A for ; Tue, 18 May 2004 22:35:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 73574-09 for ; Tue, 18 May 2004 22:35:37 -0300 (ADT) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by svr1.postgresql.org (Postfix) with ESMTP id CD145D1B191 for ; Tue, 18 May 2004 22:35:32 -0300 (ADT) Received: from localhost.localdomain (c-24-15-84-197.client.comcast.net[24.15.84.197]) by comcast.net (sccrmhc13) with ESMTP id <200405190135360160087n00e>; Wed, 19 May 2004 01:35:36 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i4J1XXPP024370; Tue, 18 May 2004 20:33:33 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i4J1XWYT024367; Tue, 18 May 2004 20:33:32 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Subject: Re: Set Timestamp From: mike g Reply-To: mike@thegodshalls.com To: Hemapriya Cc: pgsql-admin@postgresql.org In-Reply-To: <20040518141735.20500.qmail@web21327.mail.yahoo.com> References: <20040518141735.20500.qmail@web21327.mail.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1084930412.24296.3.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Tue, 18 May 2004 20:33:32 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/188 X-Sequence-Number: 13504 Maybe this will help. http://www.postgresql.org/docs/7.4/static/datatype-datetime.html On Tue, 2004-05-18 at 09:17, Hemapriya wrote: > Hi, > > Does anyone know how to set timestamp values in > postgres. > > Thanks in Advance. > > - Priya > > > > > __________________________________ > Do you Yahoo!? > SBC Yahoo! - Internet access at a great low price. > http://promo.yahoo.com/sbc/ > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster