Well then, the client needs to do the work since the client is the only side that knows the users timezone. Assuming you have a browser for a client I think you're stuck with the solution I had which was require the user to store (in the db, or in a cookie) their timezone and do 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 to your situation. Server is in another time zone from the user. I want the timestamp to be relative to the user, not the server. Maybe do something in grenwich time, then interpret all queries from the db . . . ? kind regards, bill Ryan Jameson wrote: > 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 > > 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 nice if the browser sent timezone >information in the header, but as far as I know it does not. > > <>< Ryan > > -----Original Message----- > From: bill [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 13, 2002 8:55 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] MySQL timestamp field in different time zone > > How do I get a MySQL timestamp field to update itself when the server is > in a different time zone, i.e., I want it to have the date for my time > zone. > > The field updates itself automatically, of course, without being > referenced in the SQL query. I'd like to avoid having to change every > query to include tweaking the field for the different time zone. > > kind regards, > > bill hollett > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
