<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>