How to change the date format when a file is twisted in oracle

Question

I'm currently creating an export where the date format is actually dd / mm / yyyy, but when I wrap it around and see that it goes like dd / mmm / yyyy in readable format

For example, if the date in my real file is 06/10/2014 in the coil, it automatically occurs on October 6, 2014. But I do not want this format. How to keep the original?

Answer 1

You can convert your date column to a char view before exporting

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

Answer 2

, . Oracle - . , , Oracle .

, , dd/mm/yyyy,

alter session set nls_date_format = 'dd/mm/yyyy'