Use universal YYYY-MM-DD format : How do you load date fields using File Loader? : I kept getting error message: Item .... does not pass validation test. : Supposed you need to load the following lines: 4354,John Doe, 12/22/2004 : 3533,Jane Doe, 5/04/1998 : The date field is troublesome. I even changed to different formats : (MM/DD/RR, DD-MON-RR, DD-MON-RRRR) to no avail. : The workaround is creating a table with only varchar columns. : IMPORT text data into that table and INSERT to the real table with to_date : function. : But that's too cumbersome.
|