Request a Demo
Home   >   mailing lists

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
Tree view
2008/7/25 Anoop G <anoopmadavoor@gmail.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.socha@gmail.com

programista/administrator

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

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)