Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 927DC9FB36B
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; Tue,  3 Oct 2006 22:15:50 -0300 (ADT)
Received: by py-out-1112.google.com with SMTP id s49so9616pyc
	for <pgsql-sql@postgresql.org>; 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: <bf05e51c0610031815j1e57c9dar2a59204de8dbff6d@mail.gmail.com>
Date: Tue, 3 Oct 2006 20:15:49 -0500
From: "Aaron Bono" <postgresql@aranya.com>
To: "chester c young" <chestercyoung@yahoo.com>
Subject: Re: timestamps over the web - suggestions
Cc: "sql pgsql" <pgsql-sql@postgresql.org>
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 <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
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

You should probably handle this at the application level.&nbsp; How you go about it will depend on what programming language you use.<br><br>If you don't like that, check out the timezone function:<br><a href="http://www.postgresql.org/docs/8.0/static/runtime-config.html#GUC-TIMEZONE">
http://www.postgresql.org/docs/8.0/static/runtime-config.html#GUC-TIMEZONE</a><br><br>See also for an example:<br><a href="http://www.varlena.com/GeneralBits/3.php">http://www.varlena.com/GeneralBits/3.php</a><br>on how to use SET:
<br>&nbsp;&nbsp;&nbsp; set time zone 'PST8PDT';<br>&nbsp;&nbsp;&nbsp; select now();<br><br>Now if I could just find a list of time zones to use...<br><br><div><span class="gmail_quote">On 10/3/06, <b class="gmail_sendername">chester c young</b> &lt;<a href="mailto:chestercyoung@yahoo.com">
chestercyoung@yahoo.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">My server is based MST, but web clients from Maine to Hawaii, and they wish to see timestamps based in their own locale.
<br><br>Can anyone tell me how they're handling this?&nbsp; (sorry - can't get rid of my clients)<span class="ad">
<p></p></span></blockquote></div><br>==================================================================<br>&nbsp;&nbsp; Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, Inc.<br>&nbsp;&nbsp; <a href="http://www.aranya.com">http://www.aranya.com
</a><br>&nbsp;&nbsp; <a href="http://codeelixir.com">http://codeelixir.com</a><br>==================================================================

------=_Part_4995_32292271.1159924549310--