List:General Discussion« Previous MessageNext Message »
From:Andrew Hazen Date:May 29 2003 2:51pm
Subject:RE: timestamps and time zones
View as plain text  
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

-----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

"" <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
> to be GMT rather than PST, and the same for my Australian clients, and
> on.
> 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
client timezone?

For technical support contracts, goto
This email is sponsored by
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB /

MySQL General Mailing List
For list archives:
To unsubscribe:

upgrading to v 4.1Ted Rogers28 May
  • Re: upgrading to v 4.1Scott Haneda28 May
    • mysqlhotcopy script problemstu zimny28 May
    • RE: upgrading to v 4.1Daevid Vincent29 May
  • RE: upgrading to v 4.1Kieran Kelleher29 May
  • Re: upgrading to v 4.1LS29 May
    • Re: upgrading to v 4.1Jocelyn Fournier29 May
      • Re: upgrading to v 4.1LS29 May
    • timestamps and time zones2Hosts.com29 May
      • Re: timestamps and time zonesEgor Egorov29 May
        • RE: timestamps and time zonesAndrew Hazen29 May
    • Re: upgrading to v 4.1Jeremy Zawodny29 May
      • Re: upgrading to v 4.1LS30 May