From: Aaron Bono <postgresql@aranya.com>
To: chester c young <chestercyoung@yahoo.com>
Cc: sql pgsql <pgsql-sql@postgresql.org>
Subject: Re: timestamps over the web - suggestions
Date: Tue, 3 Oct 2006 20:15:49 -0500
Message-ID: <bf05e51c0610031815j1e57c9dar2a59204de8dbff6d@mail.gmail.com> (raw)
In-Reply-To: <20061003214412.82918.qmail@web54302.mail.yahoo.com>
References: <20061003214412.82918.qmail@web54302.mail.yahoo.com>
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.comhttp://codeelixir.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, chestercyoung@yahoo.com
Subject: Re: timestamps over the web - suggestions
In-Reply-To: <bf05e51c0610031815j1e57c9dar2a59204de8dbff6d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox