Time zone problem

From: "omid omoomi" <oomoomi(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Time zone problem
Date: 2002-07-10 09:24:22
Message-ID: F122u23LiC1h1jYhAOy00001a73@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,
Currently, my system is working under:
PostgreSQL 7.1.3 on i386-unknown-freebsd4.4, compiled by GCC 2.95.3

Since both the OS and PG showed me the same local time, every thing was
working fine until a few days ago(dont know exactly when and why!)
when the PG time zone seems to be some how missed(better say set to UTC),
and I think it is the real cause. May be it is because of any lately
automatic summer/winter time conversions by the system & ...

At the moment, this is what I get from the OS and PG in a same time:

omid=# \! date
Wed Jul 10 13:16:15 IRST 2002

omid=# select now();
now
------------------------
2002-07-10 08:46:15+00

I want to have both the OS and the PG with the same time zone of Iran time.
Any idea about why it has happen like this?

TIA
Omid Omoomi

PS) I don't think the "SET time zone" command could help me because I want
the time zone to be permanent for all the connections.

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

Browse pgsql-general by date

  From Date Subject
Next Message Sam Liddicott 2002-07-10 10:03:39 Re: I am being interviewed by OReilly
Previous Message Curt Sampson 2002-07-10 09:23:40 Re: I am being interviewed by OReilly