From chestercyoung@yahoo.com Tue Oct 3 21:44:23 2006 Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id F22559FA259 for ; Tue, 3 Oct 2006 18:44:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 50627-01 for ; Tue, 3 Oct 2006 21:44:13 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web54302.mail.yahoo.com (web54302.mail.yahoo.com [206.190.49.112]) by postgresql.org (Postfix) with SMTP id 8108E9F9F0C for ; Tue, 3 Oct 2006 18:44:13 -0300 (ADT) Received: (qmail 82920 invoked by uid 60001); 3 Oct 2006 21:44:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ZaGpua2tPZwb7zh9Xbk5TXE/uhNxDI1JXNkFGC2iRV6t8OdoGq+ffwBDQ8eBNEp6TVa7SDtwSKLoh5EN2Kvm4gH9q3Q30Q3lzcZIbKxeqC5s8vfF8cXBx/QuE9ejL+NRdrM6ZzvohGOb2sfH4VhTUmbxQeJIOzfymavX9E3DVlU= ; Message-ID: <20061003214412.82918.qmail@web54302.mail.yahoo.com> Received: from [68.35.2.64] by web54302.mail.yahoo.com via HTTP; Tue, 03 Oct 2006 14:44:12 PDT Date: Tue, 3 Oct 2006 14:44:12 -0700 (PDT) From: chester c young Subject: timestamps over the web - suggestions To: sql pgsql MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-287910422-1159911852=:75752" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.73 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_30_40, HTML_MESSAGE X-Spam-Level: *** X-Archive-Number: 200610/29 X-Sequence-Number: 26418 --0-287910422-1159911852=:75752 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit My server is based MST, but web clients from Maine to Hawaii, and they wish to see timestamps based in their own locale. Can anyone tell me how they're handling this? (sorry - can't get rid of my clients) --------------------------------- Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail. --0-287910422-1159911852=:75752 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit My server is based MST, but web clients from Maine to Hawaii, and they wish to see timestamps based in their own locale.

Can anyone tell me how they're handling this?  (sorry - can't get rid of my clients)

Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail. --0-287910422-1159911852=:75752-- From postgresql@aranya.com Wed Oct 4 01:15:58 2006 Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 927DC9FB36B for ; Tue, 3 Oct 2006 22:15:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 52083-03 for ; Tue, 3 Oct 2006 22:15:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.183]) by postgresql.org (Postfix) with ESMTP id D3A479FB3DF for ; Tue, 3 Oct 2006 22:15:50 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id s49so9616pyc for ; Tue, 03 Oct 2006 18:15:49 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=MaZpHKLgQatPHYBteX6fb1XAQzhZsfSc9JG3nvgZD28EWczaeZqlsswuKQ+r4NndJKPtCliCgOvEjKUTWFWz/IlP0wKD8NirbAGAYca0WUd2xruixjvvxy5ar41XFxxBpuplpJLztBvhdK/AvwRsooE+umfe51d9iQZ+FNwsf0I= Received: by 10.35.127.7 with SMTP id e7mr88610pyn; Tue, 03 Oct 2006 18:15:49 -0700 (PDT) Received: by 10.35.78.6 with HTTP; Tue, 3 Oct 2006 18:15:49 -0700 (PDT) Message-ID: Date: Tue, 3 Oct 2006 20:15:49 -0500 From: "Aaron Bono" To: "chester c young" Subject: Re: timestamps over the web - suggestions Cc: "sql pgsql" In-Reply-To: <20061003214412.82918.qmail@web54302.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4995_32292271.1159924549310" References: <20061003214412.82918.qmail@web54302.mail.yahoo.com> X-Google-Sender-Auth: 8e148165381d8db9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.673 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/31 X-Sequence-Number: 26420 ------=_Part_4995_32292271.1159924549310 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline You should probably handle this at the application level. How you go about it will depend on what programming language you use. If you don't like that, check out the timezone function: http://www.postgresql.org/docs/8.0/static/runtime-config.html#GUC-TIMEZONE See also for an example: http://www.varlena.com/GeneralBits/3.php on how to use SET: set time zone 'PST8PDT'; select now(); Now if I could just find a list of time zones to use... On 10/3/06, chester c young wrote: > > My server is based MST, but web clients from Maine to Hawaii, and they > wish to see timestamps based in their own locale. > > Can anyone tell me how they're handling this? (sorry - can't get rid of > my clients) > > ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_4995_32292271.1159924549310 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline You should probably handle this at the application level.  How you go about it will depend on what programming language you use.

If you don't like that, check out the timezone function:
http://www.postgresql.org/docs/8.0/static/runtime-config.html#GUC-TIMEZONE

See also for an example:
http://www.varlena.com/GeneralBits/3.php
on how to use SET:
    set time zone 'PST8PDT';
    select now();

Now if I could just find a list of time zones to use...

On 10/3/06, chester c young < chestercyoung@yahoo.com> wrote:
My server is based MST, but web clients from Maine to Hawaii, and they wish to see timestamps based in their own locale.

Can anyone tell me how they're handling this?  (sorry - can't get rid of my clients)


==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
================================================================== ------=_Part_4995_32292271.1159924549310-- From lbayuk@pobox.com Wed Oct 4 01:35:51 2006 Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BA04F9FB213 for ; Tue, 3 Oct 2006 22:35:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 51869-08 for ; Tue, 3 Oct 2006 22:35:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 824E49FA5B5 for ; Tue, 3 Oct 2006 22:35:47 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 071C130E1A; Wed, 4 Oct 2006 03:35:46 +0200 (MET DST) From: ljb X-Newsgroups: pgsql.sql Subject: Re: timestamps over the web - suggestions Date: Wed, 4 Oct 2006 01:35:36 +0000 (UTC) Organization: Hub.Org Networking Services Lines: 17 Message-ID: References: <20061003214412.82918.qmail@web54302.mail.yahoo.com> X-Complaints-To: usenet@news.hub.org User-Agent: slrn/0.9.8.1 (Linux) To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/32 X-Sequence-Number: 26421 chestercyoung@yahoo.com wrote: > > My server is based MST, but web clients from Maine to Hawaii, and they wish to see timestamps based in their own locale. > > Can anyone tell me how they're handling this? (sorry - can't get rid of my clients) Here's a bit of JavaScript that might work for you. It sets a cookie to the user's timezone offset (vs GMT, in minutes). You put something like this on an initial page (portal, login page, whatever), and then subsequent pages will be requested along with the timezone cookie. If you are using PHP, for example, your scripts just access $_COOKIE['timezone'] and adjust things accordingly for the user's timezone. From bruno@wolff.to Fri Oct 6 18:17:19 2006 Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 59C9B9FB29F for ; Fri, 6 Oct 2006 15:17:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 02086-04 for ; Fri, 6 Oct 2006 15:17:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id C64399FA6BB for ; Fri, 6 Oct 2006 15:17:15 -0300 (ADT) Received: (qmail 3125 invoked by uid 500); 6 Oct 2006 18:27:26 -0000 Date: Fri, 6 Oct 2006 13:27:26 -0500 From: Bruno Wolff III To: chester c young Cc: sql pgsql Subject: Re: timestamps over the web - suggestions Message-ID: <20061006182726.GA655@wolff.to> Mail-Followup-To: Bruno Wolff III , chester c young , sql pgsql References: <20061003214412.82918.qmail@web54302.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20061003214412.82918.qmail@web54302.mail.yahoo.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.048 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200610/84 X-Sequence-Number: 26473 On Tue, Oct 03, 2006 at 14:44:12 -0700, chester c young wrote: > My server is based MST, but web clients from Maine to Hawaii, and they wish to see timestamps based in their own locale. > > Can anyone tell me how they're handling this? (sorry - can't get rid of my clients) Do they login in as themselves? If so, perhaps storing a timezone for each client would work in your case.