I have to get the clarification on timezone and locale settings.
In our webapplication, the db is hosted in germany. But we have clients from america, using our web-client. All the data calculations in the backend are using central european timezone. So, clients in america are getting the date time with a time representation in central european timezone (b'coz the display of date time is not considering timezone).
Now, we want to use the timezone considerations in our display. So, i have the following question:
1) Is it good to handle the timezone settings in the client side OR in server side (db)?
2) If we do it in client side, how can i get the timezone settings of the user??
3) Is timezone bundled with locale?? B'coz we are setting the OS locale to en_US (purposely).
I have gone thru the java docs, but i m not getting a clear idea.
Can someone help?