System date format problem with DB
807588Feb 24 2009 — edited Feb 26 2009Hi 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, thats why I really need to know HOW CAN I GET THE SYSTEM DATE FORMAT
..
PLEASE HELP!!