Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id B9E8C2E0054 for ; Mon, 31 Mar 2008 06:40:02 -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 08769-07 for ; Mon, 31 Mar 2008 06:40:02 -0300 (ADT) X-Greylist: delayed 00:19:46.780586 by SQLgrey-1.7.5 Received: from intern.proventis.net (intern.proventis.net [87.234.204.123]) by developer.postgresql.org (Postfix) with ESMTP id 293402E0035 for ; Mon, 31 Mar 2008 06:40:02 -0300 (ADT) Received: from server1.proventis.net (unknown [192.168.22.250]) by intern.proventis.net (Postfix) with ESMTP id 476FA2B5CE for ; Mon, 31 Mar 2008 11:20:12 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id DB33FC44299 for ; Mon, 31 Mar 2008 11:20:12 +0200 (CEST) Received: from server1.proventis.net ([127.0.0.1]) by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18492-07 for ; Mon, 31 Mar 2008 11:20:12 +0200 (CEST) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id 6EFAFC44297 for ; Mon, 31 Mar 2008 11:20:12 +0200 (CEST) Message-ID: <47F0ACCC.7070403@proventis.net> Date: Mon, 31 Mar 2008 11:20:12 +0200 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 2.0.0.12 (X11/20080213) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: what is the origin of postgreSQL time References: <47F0A958.2040608@nsoft.lt> In-Reply-To: <47F0A958.2040608@nsoft.lt> Content-Type: multipart/mixed; boundary="------------070306040405080107040108" X-Virus-Scanned: by amavisd-new at proventis.net X-Archive-Number: 200803/270 X-Sequence-Number: 28753 This is a multi-part message in MIME format. --------------070306040405080107040108 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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 > --------------070306040405080107040108 Content-Type: text/x-vcard; charset=utf-8; name="t_markus.vcf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="t_markus.vcf" YmVnaW46dmNhcmQNCmZuOlRob21hcyBNYXJrdXMNCm46TWFya3VzO1Rob21hcw0Kb3JnOnBy b3ZlbnRpcyBHbWJIDQphZHI6OztaaW1tZXJzdHIuIDc5LTgwO0JlcmxpbjtCZXJsaW47MTAx MTc7R2VybWFueQ0KZW1haWw7aW50ZXJuZXQ6dC5tYXJrdXNAcHJvdmVudGlzLm5ldA0KdGVs O3dvcms6KzQ5IDMwIDI5IDM2IDM5OSAyMg0KeC1tb3ppbGxhLWh0bWw6RkFMU0UNCnVybDpo dHRwOi8vd3d3LnByb3ZlbnRpcy5uZXQNCnZlcnNpb246Mi4xDQplbmQ6dmNhcmQNCg0K --------------070306040405080107040108--