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