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 74A6053762; Mon, 18 Apr 2005 10:50:59 -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 10637-01; Mon, 18 Apr 2005 13:50:49 +0000 (GMT) Received: from mx5.net.nih.gov (mailfwd.nih.gov [165.112.130.36]) by svr1.postgresql.org (Postfix) with ESMTP id BAA3953707; Mon, 18 Apr 2005 10:50:48 -0300 (ADT) Received: from mx5.net.nih.gov (localhost [127.0.0.1]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j3IDoqaq019157; Mon, 18 Apr 2005 09:50:52 -0400 Received: from WATSON (vpn-165-112-10-50.net.nih.gov [165.112.10.50]) by mx5.net.nih.gov (8.12.10/8.11.6) with SMTP id j3IDopKe019151; Mon, 18 Apr 2005 09:50:52 -0400 Message-ID: <014c01c5441d$a3d6c970$5179f345@WATSON> From: "Sean Davis" To: , "'PostgreSQL'" , References: <20050418134134.C941E536FA@svr1.postgresql.org> Subject: Re: [SQL] How to add 1 hour in a date or time stamp? Date: Mon, 18 Apr 2005 09:50:54 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0149_01C543FC.1CA3E5D0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.084 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200504/706 X-Sequence-Number: 76619 This is a multi-part message in MIME format. ------=_NextPart_000_0149_01C543FC.1CA3E5D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dinesh, The documentation is very helpful for this topic. Typing 'add 1 hour = timestamp' into the search box at: http://www.postgresql.org/docs/8.0/interactive/index.html yields the following page as the first hit: http://www.postgresql.org/docs/8.0/static/functions-datetime.html Sean ----- Original Message -----=20 From: Dinesh Pandey=20 To: 'PostgreSQL' ; pgsql-general@postgresql.org=20 Sent: Monday, April 18, 2005 9:38 AM Subject: [SQL] How to add 1 hour in a date or time stamp? =20 How to add 1 hour in a date or time stamp? Regards Dinesh Pandey = -------------------------------------------------------------------------= --------- =20 ------=_NextPart_000_0149_01C543FC.1CA3E5D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dinesh,
 
The documentation is very helpful for = this=20 topic.  Typing 'add 1 hour timestamp' into the search box = at:
 
http:/= /www.postgresql.org/docs/8.0/interactive/index.html
 
yields the following page as the first=20 hit:
 
http://www.postgresql.org/docs/8.0/static/functions-datetime.html
 
Sean
 
----- Original Message -----
From:=20 Dinesh = Pandey=20
To: 'PostgreSQL' ; pgsql-general@postgresql.org= =20
Sent: Monday, April 18, 2005 = 9:38=20 AM
Subject: [SQL] How to add 1 = hour in a=20 date or time stamp?

 

How to add 1 hour in a = date or=20 time stamp?

Regards
Dinesh=20 Pandey


-------------------------------------------------------------------= ---------------

 

------=_NextPart_000_0149_01C543FC.1CA3E5D0--