RE: [PHP-DB] MySQL timestamp field in different time zone From: Ryan Jameson (USA) (RJameson <email protected>)
Date: 06/13/02

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 <email protected>]
Sent: Thursday, June 13, 2002 8:55 AM
To: php-db <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