Anoop G wrote:
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 )?.
1. If you have a recent version of PostgreSQL use clock_timestamp()
2. Why are you using timestamp without timezone?
SELECT clock_timestamp();
clock_timestamp
--------------------------------
25/07/2008 10:21:58.464055 BST
SET timezone='EST';
SELECT clock_timestamp();
clock_timestamp
--------------------------------
25/07/2008 04:22:19.584367 EST
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
