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

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 <email protected>]
Sent: Thursday, June 13, 2002 2:03 PM
To: php-db <email protected>
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 <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: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 

-- 
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