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?

    a578a740-e461-4b4c-938e-a48d4411c4b1

      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.