Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: t_markus.vcf
Description: text/x-vcard (266 bytes)

In response to

Responses

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group