List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:May 29 2003 11:19am
Subject:Re: timestamps and time zones
View as plain text  
"" <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
This email is sponsored by
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB /

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