Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

System date format problem with DB

807588Feb 24 2009 — edited Feb 26 2009
Hi all,
Is my first topic in this forum and I really need help…
My problem is the following one:
I have a client/server java application and it is used by many users, and I detect that some of this user at the time to update some date fields on the data base, the date is stored wrong. For example the system takes the date from a JFormattedTextField dd/mm/yyyy(system requirement), and when I create the query I send to the DB mm/dd/yyyy and for the users that have the system date format (under regional and language options) on mm/dd/yyyy there is no problem, but the users with system data format dd/mm/yyyy the date is stored swapped. I try using locale settings to avoid this issue, but since the date format can be changed no mattering the selected locale, many of the final users had for example a United States locale and a date format dd/mm/yyyy instead of mm/dd/yyyy, that’s why I really need to know HOW CAN I GET THE SYSTEM DATE FORMAT…..
PLEASE HELP!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2009
Added on Feb 24 2009
19 comments
242 views