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

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

Hai all,

my postgres version is PostgreSQL 8.1.8 didn't support clock_timestamp()

regards:

Anoop