How do I mask a date from Text File? Help 1

[bmann]

I am importing data and I need to mask a date from a text file using Toad. The date looks like this:

2001-04-06 02:15:17

 

[nagornyi]

YYYY-MM-DD HH24:MI:SS

 

[bmann]

thanks nagornyi. But I am getting an error. Her is the error:

ORA-01841: (full) year must be between -4713 and +9999, and not be 0


How do I fix this problem?

 

[nagornyi]

Looks like some records do not fit into this mask. You may either ignore them using pl/sql exceptions, or fix them manually before converting. Specifically, you may look into the first 4 characters of your data to see what is going wrong with the year. Like
select substr(the_text_field, 1, 4) from the_table