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

From Anoop G
Subject Re: postgres time zone settings(time difference in Server and client)
Date
Msg-id 1a027d210807250212k171cfd83yd5989ca6cf8f1ad8@mail.gmail.com
Whole thread Raw
Responses Re: postgres time zone settings(time difference in Server and client)  (Richard Huxton <dev@archonet.com>)
Re: postgres time zone settings(time difference in Server and client)  ("Pawel Socha" <pawel.socha@gmail.com>)
List pgsql-sql
<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> 

pgsql-sql by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Arrays, types and prodedures
Next
From: Richard Huxton
Date:
Subject: Re: postgres time zone settings(time difference in Server and client)