Re: postgres time zone settings(time difference in Server and client) - Mailing list pgsql-sql

From Pawel Socha
Subject Re: postgres time zone settings(time difference in Server and client)
Date
Msg-id cc4f12900807250224j776ff71cjdf06c11a082f7e6e@mail.gmail.com
Whole thread Raw
In response to Re: postgres time zone settings(time difference in Server and client)  ("Anoop G" <anoopmadavoor@gmail.com>)
List pgsql-sql
<div dir="ltr">2008/7/25 Anoop G <<a href="mailto:anoopmadavoor@gmail.com">anoopmadavoor@gmail.com</a>>:<br
/><divclass="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt
0pt0pt 0.8ex; padding-left: 1ex;"><div dir="ltr"><br />Hai all,<br /><br />   I have  database running on server. I am
usingpython to run my application.postgres client is running on the clients .All clients are connected to a single
databaserunning on server. Each time application starts ,the login time is taken from server  using the query<br />
"""selectCAST ( timeofday() AS timestamp"""<br /><br />But the problem the time which I got is different from that of
servermachine . I Think the postgres client is adding some values to the server time. How can I solve this .Is there
anyconfiguration setting for client to solve this?.In which location client's configuration file is stored( I am using
Linux(Debian)?.<br /><br />here the result I got:<br /><br />The correct time in server:   2008-07-25 14:16:54<br /><br
/>ButWhat i got from client (with database cursor of sever database):  <br />   2008-07-25 19:46:33.46  (difference of
morethan 5 Hr ) Where this difference come?<br /><br />any one know the answer pls help me.<br /><br />Thanks in
advance<br/><br />Anoop<br /><br /><br /><br /></div></blockquote></div><br />server localtime is correct ?<br
/>/etc/localtime...<br /><br />-- <br />--<br />Serdecznie pozdrawiam<br /><br />Pawel Socha<br /><a
href="mailto:pawel.socha@gmail.com">pawel.socha@gmail.com</a><br/><br />programista/administrator<br /><br />perl -le
's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%&-;^[%"`-{ a%%s%%$_%ee' </div> 

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: postgres time zone settings(time difference in Server and client)
Next
From: "Anoop G"
Date:
Subject: Re: postgres time zone settings(time difference in Server and client)