SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Loading dates

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Loading dates
Author Message
Khoi N. Bui



Joined: 21 Nov 2005
Posts: 3

Post Loading dates Reply with quote

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.


Tue Nov 29, 2005 6:16 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Loading dates Reply with quote

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.

Tue Nov 29, 2005 7:05 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.