APEX

Hi All,

I am working on an application which will be used globally. I need to show users the date time values w.r.t to their local time zone.

At the database level I can use the data type "timestamp with local time zone", do "alter session set time_zone='desired value' and see the time.

Now the question is how do I do set the time_zone for user from APEX. Is there a way to capture the timezone from browser or PC and set it in APEX (Preferred way)? Or if I create a user for each Geography and set there session TIMEZONE, then how?

Please, can any one show me how to do this?

Thanks and Regards
Amar Dewri