From denis@exonium.net Sat Mar 1 14:48:31 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D4358474E61 for ; Sat, 1 Mar 2003 09:48:31 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 59260-01 for ; Sat, 1 Mar 2003 09:48:30 -0500 (EST) Received: from notelab.net (unknown [193.95.196.101]) by postgresql.org (Postfix) with ESMTP id 0D961474E5C for ; Sat, 1 Mar 2003 09:48:30 -0500 (EST) Received: from neo ([213.143.85.125]) by notelab.net (8.11.6/8.11.6) with ESMTP id h21DhUL29310 for ; Sat, 1 Mar 2003 15:43:31 +0200 From: "Denis Arh" To: Subject: Epoch extraction Date: Sat, 1 Mar 2003 15:47:03 +0100 Message-ID: <006401c2e001$7794ba20$0a00000a@neo> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0065_01C2E009.D9592220" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/6 X-Sequence-Number: 12046 This is a multi-part message in MIME format. ------=_NextPart_000_0065_01C2E009.D9592220 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit When i extract epoch from field (timestamp(0) without time zone) I get the time that is set in that field plus one hour... Is that a bug or am I just missing something.... Regards, Denis Arh ------=_NextPart_000_0065_01C2E009.D9592220 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
When i ex= tract epoch=20 from field (timestamp(0) without time zone) I get the time that is set= in=20 that field plus one hour...
Is that a= bug or am=20 I just missing something....
 
 
Regards,
Denis=20 Arh
------=_NextPart_000_0065_01C2E009.D9592220-- From denis@exonium.net Sat Mar 1 14:53:27 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D0776474E44 for ; Sat, 1 Mar 2003 09:53:27 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 58272-02 for ; Sat, 1 Mar 2003 09:53:26 -0500 (EST) Received: from notelab.net (unknown [193.95.196.101]) by postgresql.org (Postfix) with ESMTP id 4CBD8474E42 for ; Sat, 1 Mar 2003 09:53:26 -0500 (EST) Received: from neo ([213.143.85.125]) by notelab.net (8.11.6/8.11.6) with ESMTP id h21DndL29333 for ; Sat, 1 Mar 2003 15:49:40 +0200 From: "Denis Arh" To: Subject: Epoch extraction Date: Sat, 1 Mar 2003 15:53:10 +0100 Message-ID: <006901c2e002$5398bb70$0a00000a@neo> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006A_01C2E00A.B55D2370" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/7 X-Sequence-Number: 12047 This is a multi-part message in MIME format. ------=_NextPart_000_006A_01C2E00A.B55D2370 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit When i extract epoch from field (timestamp(0) without time zone) I get the time that is set in that field plus one hour... Is that a bug or am I just missing something.... Regards, Denis Arh ------=_NextPart_000_006A_01C2E00A.B55D2370 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
When i ex= tract epoch=20 from field (timestamp(0) without time zone) I get the time that is set= in=20 that field plus one hour...
Is that a= bug or am=20 I just missing something....
 
 
Regards,
Denis=20 Arh
------=_NextPart_000_006A_01C2E00A.B55D2370-- From tgl@sss.pgh.pa.us Sat Mar 1 17:07:14 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F1B4A474E5C for ; Sat, 1 Mar 2003 12:07:14 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 15222-08 for ; Sat, 1 Mar 2003 12:07:14 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 4A3B5474E42 for ; Sat, 1 Mar 2003 12:07:13 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h21H7F5u012132; Sat, 1 Mar 2003 12:07:15 -0500 (EST) To: "Denis Arh" Cc: pgsql-sql@postgresql.org Subject: Re: Epoch extraction In-reply-to: <006901c2e002$5398bb70$0a00000a@neo> References: <006901c2e002$5398bb70$0a00000a@neo> Comments: In-reply-to "Denis Arh" message dated "Sat, 01 Mar 2003 15:53:10 +0100" Date: Sat, 01 Mar 2003 12:07:14 -0500 Message-ID: <12131.1046538434@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/11 X-Sequence-Number: 12051 "Denis Arh" writes: > When i extract epoch from field (timestamp(0) without time zone) I get > the time that is set in that field plus one hour... I suppose you live in a GMT+1 time zone? > Is that a bug or am I just missing something.... See thread at http://archives.postgresql.org/pgsql-bugs/2003-02/msg00069.php regards, tom lane