Re: 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: php-db@lists.php.net > 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:bill@billtron.com] > Sent: Thursday, June 13, 2002 8:55 AM > To: php-db@lists.php.net > 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