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

2002-06-13 Thread Ryan Jameson (USA)
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

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

2002-06-13 Thread Ryan Jameson (USA)
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: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL timestamp field in different time zone

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

2002-06-13 Thread bill
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: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL timestamp field in different time zone I had

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

2002-06-13 Thread Ryan Jameson (USA)
the calculation either on the sql or upon displaying but it has to happen on the client. Ryan -Original Message- From: bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 2:03 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL timestamp field in different time zone No, it is similar