> 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.

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]

Reply via email to