Time zone problem
От | omid omoomi |
---|---|
Тема | Time zone problem |
Дата | |
Msg-id | F122u23LiC1h1jYhAOy00001a73@hotmail.com обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: