Re: postgres time zone settings(time difference in Server and client)

2008/7/25 Anoop G <anoopmadavoor(at)gmail(dot)com>:

>
> Hai all,
>
> I have database running on server. I am using python to run my
> application.postgres client is running on the clients .All clients are
> connected to a single database running on server. Each time application
> starts ,the login time is taken from server using the query
> """select CAST ( timeofday() AS timestamp"""
>
> But the problem the time which I got is different from that of server
> machine . I Think the postgres client is adding some values to the server
> time. How can I solve this .Is there any configuration setting for client to
> solve this?.In which location client's configuration file is stored( I am
> using Linux(Debian )?.
>
> here the result I got:
>
> The correct time in server: 2008-07-25 14:16:54
>
> But What i got from client (with database cursor of sever database):
> 2008-07-25 19:46:33.46 (difference of more than 5 Hr ) Where this
> difference come?
>
> any one know the answer pls help me.
>
> Thanks in advance
>
> Anoop
>
>
>
>
server localtime is correct ?
/etc/localtime ...

--
--
Serdecznie pozdrawiam

Pawel Socha
pawel(dot)socha(at)gmail(dot)com

programista/administrator

perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`-{
a%%s%%$_%ee'