I had a similar issue where I wanted timestamps to be relative to the user. I didn't
find any better way then to create some profile data that contained their timezone and
allow them to save that data. Then anytime I displayed a timestamp I added the
timezone shift to the stamp. It would be
BTW... are you saying that you plan to move the MySQL server around to different time
zones? Why would you do that?
-Original Message-
From: Ryan Jameson (USA)
Sent: Thursday, June 13, 2002 9:44 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL timestamp field in different time zone
saying that you plan to move the MySQL server around to different
time zones? Why would you do that?
-Original Message-
From: Ryan Jameson (USA)
Sent: Thursday, June 13, 2002 9:44 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL timestamp field in different time zone
I had
the calculation either on the sql or upon displaying but
it has to happen on the client.
Ryan
-Original Message-
From: bill [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 2:03 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL timestamp field in different time zone
No, it is similar