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

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:bill@billtron.com] Sent: Thursday, June 13, 2002 2:03 PM To: php-db@lists.php.net 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: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php