[PHP] Architecture : Handling timezones in a web application

2001-10-29 Thread l0t3k

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 ?



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




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

2001-10-29 Thread Erik H. Mathy

 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]