How to change the date format when the file is spooled in oracle

Question

Currently i'm generating a export where the date format is actually dd/mm/yyyy but when i spool it and see it is coming as dd/mmm/yyyy in a readable format

For example if the date in my real file is 06/10/2014 in the spool it automatically is coming 06-Oct-2014. But i don't want this format. How to retain the original one?

Answer 1

You can convert your date column to char representation before exporting

to_char(date_column, 'dd/mm/yyyy')