Skip site navigation (1) Skip section navigation (2)

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

From: "Pawel Socha" <pawel(dot)socha(at)gmail(dot)com>
To: "Anoop G" <anoopmadavoor(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: postgres time zone settings(time difference in Server and client)
Date: 2008-07-25 09:24:22
Message-ID: cc4f12900807250224j776ff71cjdf06c11a082f7e6e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
2008/7/25 Anoop G <anoopmadavoor(at)gmail(dot)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(dot)socha(at)gmail(dot)com

programista/administrator

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

In response to

pgsql-sql by date

Next:From: Anoop GDate: 2008-07-25 10:02:42
Subject: Re: postgres time zone settings(time difference in Server and client)
Previous:From: Richard HuxtonDate: 2008-07-25 09:23:22
Subject: Re: postgres time zone settings(time difference in Server and client)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group