Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id BA04F9FB213
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <lbayuk@pobox.com>
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: <efv357$2qf4$1@news.hub.org>
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.

<script language="JavaScript1.1"><!--
var d = new Date();
document.cookie = "timezone="+d.getTimezoneOffset();
--></script>