From dpandey@secf.com Mon Apr 18 13:41:46 2005 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 0741A53757; Mon, 18 Apr 2005 10:41:46 -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 99074-07; Mon, 18 Apr 2005 13:41:43 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id C941E536FA; Mon, 18 Apr 2005 10:41:34 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R) with ESMTP id md50000656915.msg; Mon, 18 Apr 2005 06:41:36 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" , Subject: How to add 1 hour in a date or time stamp? Date: Mon, 18 Apr 2005 19:08:21 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0063_01C54449.FF44D690" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcVEG+NVrepNuwXdQ/WA9m5lQNuxVg== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Mon, 18 Apr 2005 06:41:36 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDAV-Processed: mail.secf.com, Mon, 18 Apr 2005 06:41:37 -0700 Message-Id: <20050418134134.C941E536FA@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.472 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_90_100, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200504/705 X-Sequence-Number: 76618 This is a multi-part message in MIME format. ------=_NextPart_000_0063_01C54449.FF44D690 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit How to add 1 hour in a date or time stamp? Regards Dinesh Pandey ---------------------------------------------------------------------------- ------ ------=_NextPart_000_0063_01C54449.FF44D690 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

Regards
Dinesh Pandey

-----------------------------------= -----------------------------------------------<= /font>

------=_NextPart_000_0063_01C54449.FF44D690-- From sdavis2@mail.nih.gov Mon Apr 18 13:50:59 2005 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-- From ler@lerctr.org Mon Apr 18 13:53:42 2005 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 From achill@matrix.gatewaynet.com Mon Apr 18 13:57:24 2005 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 D698953818; Mon, 18 Apr 2005 10:57:24 -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 14674-01; Mon, 18 Apr 2005 13:57:15 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id 9DD2A53768; Mon, 18 Apr 2005 10:57:12 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id j3IEdL1M018679; Mon, 18 Apr 2005 17:39:21 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id j3IEdJoB018675; Mon, 18 Apr 2005 17:39:21 +0300 Date: Mon, 18 Apr 2005 17:39:19 +0300 (EEST) From: Achilleus Mantzios To: Dinesh Pandey Cc: "'PostgreSQL'" , Subject: Re: [SQL] How to add 1 hour in a date or time stamp? In-Reply-To: <20050418134134.C941E536FA@svr1.postgresql.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/708 X-Sequence-Number: 76621 O Dinesh Pandey έγραψε στις Apr 18, 2005 : > > > How to add 1 hour in a date or time stamp? # SELECT now() + '1 hour'::interval; > > Regards > Dinesh Pandey > > > ---------------------------------------------------------------------------- > ------ > > > > > > -- -Achilleus