Architecture : Handling timezones in a web application
| From: | l0t3k | Date: | Mon, 29 Oct 2001 21:13:41 +0000 |
| Subject: | Architecture : Handling timezones in a web application | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-72775@lists.php.net to get a copy of this message | ||
we have developed an application that in use at institutions throughout the
U.S and hosted centrally, and we need to figure out how to handle timezone
issues for time related data in the database. how have others handled the
issue ?
our thought is to associate a timezone with the institution and store all
times in the DB as UTC. conversions from UTC to local time would happen only
as data is displayed in the browser.
any thoughts ?