Re: what is the origin of postgreSQL time

[Thomas Markus <t(dot)markus(at)proventis(dot)net>]

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

begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:t(dot)markus(at)proventis(dot)net
tel;work:+49 30 29 36 399 22
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard