RE: [PHP] Architecture : Handling timezones in a web application

> we have developed an application that in use at institutions > throughout the U.S and hosted centrally, Sweet! > 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. That'll work. > any thoughts ? What you've thought of is fine. Or you can do a small clientside Javascript function that's put into your pages via an include();. - Erik P.S. That's if you like or use Javascript. Many folks here and in other places don't like Javascript for anything except for pretty image switches...hey, whatever floats your boat!! :)