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
any one know the answer pls help me.
Thanks in advance
pgsql-sql by date
|Next:||From: Richard Huxton||Date: 2008-07-25 09:23:22|
|Subject: Re: postgres time zone settings(time difference in Server and
|Previous:||From: Pavel Stehule||Date: 2008-07-25 08:38:49|
|Subject: Re: Arrays, types and prodedures|