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