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
