Re: what is the origin of postgreSQL time

From: Thomas Markus <t(dot)markus(at)proventis(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: what is the origin of postgreSQL time
Date: 2008-03-31 09:20:12
Message-ID: 47F0ACCC.7070403@proventis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>

Attachment Content-Type Size
t_markus.vcf text/x-vcard 266 bytes

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julius Tuskenis 2008-03-31 10:18:41 Re: what is the origin of postgreSQL time
Previous Message Julius Tuskenis 2008-03-31 09:05:28 what is the origin of postgreSQL time