If I use select current_timestamp AT TIME ZONE 'EEST' I get good time
(EEST - I'm in Lithuania). But how do I make postgreSQL use system time
by default? The thing is we have 8 servers working and none of them is
affected by this issue. Only one refuses to switch to summer time.
Julius Tuskenis
Thomas Markus rašė:
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
------------------------------------------------------------------------
--
Julius Tuskenis
Programuotojas
UAB nSoft
mob. +37068233050
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
