X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C2DB1537DD; Mon, 18 Apr 2005 10:53:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11681-04; Mon, 18 Apr 2005 13:53:39 +0000 (GMT) Received: from lerami.lerctr.org (lerami.lerctr.org [192.147.25.11]) by svr1.postgresql.org (Postfix) with ESMTP id 6788053783; Mon, 18 Apr 2005 10:53:35 -0300 (ADT) Received: from lerlaptop.lerctr.org ([192.147.25.14]:32927) by lerami.lerctr.org with esmtpsa (TLSv1:RC4-MD5:128) (Exim 4.51) id 1DNWgz-00053G-3n; Mon, 18 Apr 2005 08:53:39 -0500 From: Larry Rosenman Organization: LERCTR Consulting To: dpandey@secf.com Subject: Re: [SQL] How to add 1 hour in a date or time stamp? Date: Mon, 18 Apr 2005 08:53:37 -0500 User-Agent: KMail/1.7.1 Cc: "'PostgreSQL'" , pgsql-general@postgresql.org References: <20050418134134.C941E536FA@svr1.postgresql.org> In-Reply-To: <20050418134134.C941E536FA@svr1.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200504180853.37372.ler@lerctr.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/707 X-Sequence-Number: 76620 On Monday 18 April 2005 08:38 am, Dinesh Pandey wrote: > How to add 1 hour in a date or time stamp? timestamp + '1 hour'::interval is one way. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-351-4152 E-Mail: ler@lerctr.org US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611