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

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