X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 93DBE52B02 for ; Wed, 20 Jul 2005 22:30:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15979-08 for ; Thu, 21 Jul 2005 01:30:06 +0000 (GMT) Received: from tomts5-srv.bellnexxia.net (tomts5.bellnexxia.net [209.226.175.25]) by svr1.postgresql.org (Postfix) with ESMTP id 5F03052AD5 for ; Wed, 20 Jul 2005 22:30:03 -0300 (ADT) Received: from [192.168.200.100] ([69.158.4.60]) by tomts5-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with ESMTP id <20050721013007.TZEF26128.tomts5-srv.bellnexxia.net@[192.168.200.100]>; Wed, 20 Jul 2005 21:30:07 -0400 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Wed, 20 Jul 2005 21:30:04 -0400 Subject: Re: Times and time zones From: Lynna Landstreet To: "Gavin M. Roy" , Message-ID: In-Reply-To: <6F13DAFC-577D-4EE3-B170-18B13D8AA7FD@ehpg.net> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/22 X-Sequence-Number: 3210 On 7/20/05 7:36 PM, Gavin M. Roy wrote: > Why not just tell PostgreSQL the timezone for the user and use > timestamp with timezone and let pgsql do the rest? I believe it's > SET TIMEZONE '-8'; for PST/PDT, etc. That command works for an entire session, correct? Unfortunately, this is a travel-related site, so sometimes there are going to be arrival and departure times in different time zones, so I don't think that would work in this case. But it's likely to be useful in other applications, so thank you for the info. Lynna -- Spider Silk Design - http://www.spidersilk.net 509 St Clair W Box 73576, Toronto ON Canada M6C 1C0 Tel 416.651.2899 - Toll Free 1.866.651.2899 - Cell 416.873.9289