Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3F0732E0079 for ; Mon, 31 Mar 2008 07:18:47 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 19899-08 for ; Mon, 31 Mar 2008 07:18:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from vilnius.balt.net (vilnius.balt.net [195.14.170.14]) by developer.postgresql.org (Postfix) with ESMTP id A2A2F2E0055 for ; Mon, 31 Mar 2008 07:18:46 -0300 (ADT) Received: from nSoft.lt (unknown [217.117.29.29]) by vilnius.balt.net (Postfix) with ESMTP id 68E5738BA1F for ; Mon, 31 Mar 2008 13:18:42 +0300 (EEST) Received: from [192.168.16.191] (unknown [192.168.16.191]) by nSoft.lt (Postfix) with ESMTP id EBAF4BEFC1 for ; Mon, 31 Mar 2008 14:10:17 +0000 (GMT) Message-ID: <47F0BA81.6080405@nsoft.lt> Date: Mon, 31 Mar 2008 13:18:41 +0300 From: Julius Tuskenis User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 CC: pgsql-admin@postgresql.org Subject: Re: what is the origin of postgreSQL time References: <47F0A958.2040608@nsoft.lt> <47F0ACCC.7070403@proventis.net> In-Reply-To: <47F0ACCC.7070403@proventis.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Archive-Number: 200803/271 X-Sequence-Number: 28754 If I use select current_timestamp AT TIME ZONE 'EEST' I get good time (EEST - I'm in Lithuania). But how do I make postgreSQL use system time by default? The thing is we have 8 servers working and none of them is affected by this issue. Only one refuses to switch to summer time. Julius Tuskenis Thomas Markus rašė: > beware of timezone dst offset. try > select current_timestamp AT TIME ZONE 'MEST' > > thomas > > Julius Tuskenis schrieb: >> Hello, >> >> I have problem with postgreSQL current_timestramp. Where does it get >> its value, because it doesnt match system time. The problem appeared >> after this saturday-sunday night and is connected somehow with the >> daylight saving. Now "date" on the server returns good value, but the >> SELECT current_timestmap is 1 hour late. >> >> Postgresql 8.1.4 >> OS: Gentoo Linux >> > > ------------------------------------------------------------------------ > > > -- Julius Tuskenis Programuotojas UAB nSoft mob. +37068233050