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

what is the origin of postgreSQL time

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: pgsql-admin(at)postgresql(dot)org
Subject: what is the origin of postgreSQL time
Date: 2008-03-31 09:05:28
Message-ID: 47F0A958.2040608@nsoft.lt (view raw or flat)
Thread:
Lists: pgsql-admin
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



Responses

pgsql-admin by date

Next:From: Thomas MarkusDate: 2008-03-31 09:20:12
Subject: Re: what is the origin of postgreSQL time
Previous:From: hubert depesz lubaczewskiDate: 2008-03-31 07:51:22
Subject: Re: how to improve COPY timings or reduce data loading time using copy

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