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

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