Toad World® Forums

Date format is different when exporting to INSERT statement

I have the date format in Data Grids set to DD/MM/YYYY, and that is how dates display in query result sets.

However, if I try to export these results as an INSERT statement, the date format reverses to mm/DD/YYYY.

I've checked NLS parameters, and the date format saved there is DD/MM/RR. Is thte something else I need to change in TOAD?

What version of Toad are you using? This was fixed a long time ago.

NLS parameters has nothing to do with it.

It's version 12.1.0.22

That was fixed in version 12.9.