I think the pertinent question is how to reliably get the client's time
zone? I think you need a javascript to use the browser controls to check
the timezone setting on the local computer and add it to a form on the
page. Web page issue more than a DB issue.
Andrew Hazen
www.jatech.ca
andrewhazen@stripped
andrewhazen@stripped
-----Original Message-----
From: Egor Egorov [mailto:egor.egorov@stripped]
Sent: Thursday, May 29, 2003 7:19 AM
To: mysql@stripped
Subject: Re: timestamps and time zones
"2Hosts.com" <hosting@stripped> wrote:
> Bearing in mind the international nature of the internet, how do I
make a
> timestamp local to the user rather than local to my webserver in
Canada? If
> a user is adding a record to my database from England, I want the
timestamp
> to be GMT rather than PST, and the same for my Australian clients, and
so
> on.
>
> I will probably still use a "master" time stamp too which will be
"master
> server time" much like "ebay time".
>
> How do I go about this?
What about just add needed interval to the current time depending on
client timezone?
--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
