Oracle to_date error caused by different locales

To_date (dateFrom, ‘YYYY /mm/dd’); insert data’ 0001/9/14 ‘; After debugging, I found that the date I entered in the test window “2014/9/1” changed into “01-SEP-14” in the program. Suddenly I realized that it was September 14, 2001.

To_date (to_char(dateFrom, ‘YYYY /mm/ DD ‘),’ YYYY /mm/ DD ‘) Run again, record success.