I am trying to insert a date column into a table.
The format from the file that the date is coming from is 021101,020901,080200,etc.
How do I insert it?

using this syntax "insert into table_name (date_column_name) values (to_date('02-02-02'));"
does not seem to work. Any Idea how to make this insert work?