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--