From: | "Aaron Bono" <postgresql(at)aranya(dot)com> |
---|---|
To: | "chester c young" <chestercyoung(at)yahoo(dot)com> |
Cc: | "sql pgsql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: timestamps over the web - suggestions |
Date: | 2006-10-04 01:15:49 |
Message-ID: | bf05e51c0610031815j1e57c9dar2a59204de8dbff6d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)yahoo(dot)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
==================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | ljb | 2006-10-04 01:35:36 | Re: timestamps over the web - suggestions |
Previous Message | Graham Davis | 2006-10-03 23:03:30 | formatting intervals with to_char |