Re: what is the origin of postgreSQL time

Yes, it is undefined (#timezone = unknown) just like in other servers.

Julius

Vishal Arora rašė:
>
> Have you checked timezone parameter in postgresql.conf file?
>
> - Vishal
>
>
>
>
> ------------------------------------------------------------------------
>
> > Date: Mon, 31 Mar 2008 13:18:41 +0300
> > From: julius@nsoft.lt
> > CC: pgsql-admin@postgresql.org
> > Subject: Re: [ADMIN] what is the origin of postgreSQL time
> >
> > 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@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-admin
>
>
> ------------------------------------------------------------------------
> Windows Live Messenger : Get connected, share yourself, make a
> difference the way you chat. Check it out!
> <http://get.live.com/messenger/overview%20>


--
Julius Tuskenis
Programuotojas
UAB nSoft
mob. +37068233050