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