Re: How to show proper time to users from around the world
| From: | Per Jessen | Date: | Fri, 31 Aug 2007 09:05:31 +0000 |
| Subject: | Re: How to show proper time to users from around the world | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-261559@lists.php.net to get a copy of this message | ||
Hemanth wrote:
> Hi friends,
>
> Is there a solution to showing the proper time and date at user
> browsers and also recording proper USER times in the database
> operations in mysql
I think it's better to record UTC times only, but display them according
to the users timezone. You can do that by telling mysql which timezone
you want per session.
http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
/Per Jessen, Zürich