RE: [PHP-DB] MySQL timestamp field in different time zone

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