Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 5314C2E0072 for ; Mon, 31 Mar 2008 06:05:34 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 17642-01 for ; Mon, 31 Mar 2008 06:05:29 -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 9157F2E0035 for ; Mon, 31 Mar 2008 06:05:33 -0300 (ADT) Received: from nSoft.lt (unknown [217.117.29.29]) by vilnius.balt.net (Postfix) with ESMTP id 5758A38B964 for ; Mon, 31 Mar 2008 12:05:29 +0300 (EEST) Received: from [192.168.16.191] (unknown [192.168.16.191]) by nSoft.lt (Postfix) with ESMTP id 436D8BEFC1 for ; Mon, 31 Mar 2008 12:57:06 +0000 (GMT) Message-ID: <47F0A958.2040608@nsoft.lt> Date: Mon, 31 Mar 2008 12:05:28 +0300 From: Julius Tuskenis User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: what is the origin of postgreSQL time Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200803/269 X-Sequence-Number: 28752 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