When exporting data as csv file from SQL Navigator 5.0.0 the date format is the following:
"THURSDAY, OCTOBER 10, 2002"
But the grid and spool show dd-mon-yyyy or mm/dd/yyyy? I want the export to be the same. Is there a format setting that needs to be changed?
Properties setting for the export is incorrectly set.
There should be an option for Properties in the Export prompt that allows you to specify the format.
By default it is set with format as "TUESDAY, MAY 14, 1985", but this can be change under properties for the export.