date error function

[ramkumar15]

I am getting an error function in date format while importing the date column in oracle sql developer tool

My date format in table is 6-Nov-14 and while importing its converted to 6/11/14 eventhough the format is as 6-Nov-14 in excel.

could you please let help me out what I need to change in the date column to pick it as this format 6-Nov-14.

Plese help me out asap it would be a great help.

[gandolf989]

As long as the date is being treated like a date and the date is correct you have a formatting issue.
Just highlight the column in Excel, then select format data, choose date for data type and pick the
right format. In Sql Plus you can select any date format you want, which is different then the
setting in Excel. If you are exporting the data as a comma delimited file, you might be able to add
some formatting information to the date fields to force it to the right format. I would have to Google
to find out how to do that, but it should not be difficult.