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