This discussion is archived
2 Replies Latest reply: Nov 19, 2012 1:43 AM by Jean-MarcF RSS

Wrong date conversion while loading csv datas with the wizard

Jean-MarcF Newbie
Currently Being Moderated
Hi,

I am trying to load csv datas into a table using the wizard. Everything works fine except from the date type which is converted from DD/MM/YYYY to MM/DD/YYYY during the loading phase. A form in apex on the table print the date in the French format so the first september is transform into the ninth of january.

My database is configured in American and my client is in French and the numbers are correctly handled... ',' as the decimal separator in my client (in the CSV datas and in the restitution form) and '.' in the database.

I have tried to force the format in the format cell of the mapping page but it doesn't work. To test something else, I have created a websheet application and used a datagrid to load he same datas. The date are correctly managed.
I create a form to print the NLS infos of my session and they are all in French.

I use APEX 4.2 (I migrate from 4.1 to see if it was a version specific bug) on oracle 11.2.0.2.

regards
Jean-Marc

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points