Our EJB application which is browser based JApplet has to accomodate Internationalization(I18N). When ever we write the Date ,we write with time and with the insatnce of "GMT". The sample code looks as below to write date. _stmt.setTimestamp(1, new Timestamp(new java.util.Date().getTime()),Calendar.getInstance(TimeZone.getTimeZone("GMT")));
Though the user is sitting in a different TimeZone and inserting a record, the insert date will be always the server TimeZone which is different from the user's TimeZone. Assuming that the serve is in USA and user is in Asia, the user is trying to insert a recod at 13th at 7PM. But that record will be written as 14th at 3AM in the server side due to diffeent TimeZone. Now, the user tries to retrieve the same record immediately, he may not able to retrieve it because it is wriiten as a different day. I would like to know how to solvw this different TimeZone issues? Thanks
You're shifting your frame of reference in mid-process. You understand that if the server's in GMT+5 and the client's in GMT-10 that the record would be stamped GMT (as long as the server allowed for it), but you're expecting the record retrieved to be GMT-10! If it went IN GMT, it will come BACK GMT except as it may be converted. The only place where confusion could apply is if you wanted to enter or retrieve times in the local reference frame, in which case you simply bias the GMT based on the client's locale info - add bias going down, subtact bias coming back.
Customer surveys are for companies who didn't pay proper attention to begin with.
Joined: Aug 17, 2001
Tim, Thanks for your reply. I would like to know what is the industry I18N standard to handle different time zones and I would appreciate, if you could give provide a few examples.