> 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!! :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]