Toad World® Forums

Date format when exporting data as table inserts


Another (small) issue: in the export options dialog: I can select a date format from a list, but I can also change it - e.g. I can select the format “DD/MM/RRRR HH24:MI:SS” and change it to “DD-MM-RRRR HH24:MI:SS”.
When exporting data, however, the actual format used (in the specific case described above) reverts to “YYYY-MM-DD HH24:MI:SS”, and, when reviewing the export options, the date format field is blank (presumably because it is not in the accompanying list).

In SqlNav 5.5.4, it was not possible to edit the date format, preventing the problem to occur altogether.

I suggest to either return to the SqlNav 5.5.4 situation or allow any free-form date format (as long as it is valid!) to be entered.


Hi Dominique,

Thanks for reporting this.

We will make changes in the next release for you to validate of the value input as per your suggestion.

Thanks and regards,