Received: from sapphire.albourne.com (sapphire.albourne.com [195.212.241.227]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBFFO7006835 for ; Fri, 15 Dec 2000 10:24:07 -0500 (EST) (envelope-from alessio@albourne.com) Received: from albourne.com (akamas.albourne.com [195.212.241.254]) by sapphire.albourne.com (8.9.3/8.9.3/Albourne/CYS/1.9/MAPS) with ESMTP id RAA24092; Fri, 15 Dec 2000 17:24:19 +0200 (EET) Message-ID: <3A3A377B.3E21667B@albourne.com> Date: Fri, 15 Dec 2000 17:23:39 +0200 From: Alessio Bragadini Organization: APL Financial Services (Overseas) Ltd. X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.18pre21 i686) X-Accept-Language: it, en, sv MIME-Version: 1.0 To: Karel Zak CC: SQL for PostgreSQL list Subject: Re: Confused by timezones References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/165 X-Sequence-Number: 499 Karel Zak wrote: > Yes it's possible, but in freezed 7.1 *only*. It's 'TZ' and output is Thanks, on my experimental 7.1 works perfectly, another reason to switch as soon as possible. :-) > You must use same names (definitions) as are used in your OS > (an example on Linux at /usr/share/zoneinfo) In 7.1 works. Is it supposed to work also in 7.0? Because then it would be a configuration problem on my main system. Since I have a website with registered users, with associated timezone, I would like to show all timestamps based on the user's timezone, and the best way would be to set a session configuration. My only fear is that Apache::DBI (which reuses the same connection for different pages) could intermix such information. Any comment on this would be appreciated. Thanks -- Alessio F. Bragadini alessio@albourne.com APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-2-755750 "It is more complicated than you think" -- The Eighth Networking Truth from RFC 1925