2 Replies Latest reply on Aug 9, 2014 5:21 AM by rp0428

    Can I specify a mask to use in SQL developer for exporting date columns?


      Currently the mask defaults to DD-MON-YY, and that causes data fidelity loss.


      For example, if I export data from a column that is storing a UTC time down to the second, when I run an export on the data on that table, the best I can get is the date. Is there an option for setting the default mask somewhere? NLS does not seem to affect the export utility.