# Date format is different when exporting to INSERT statement

**URL:** <https://forums.toadworld.com/t/date-format-is-different-when-exporting-to-insert-statement/49289>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 12, 2020, 4:36pm UTC](https://forums.toadworld.com/t/date-format-is-different-when-exporting-to-insert-statement/49289 "2020-03-12T16:36:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sadouglas](https://avatars.discourse-cdn.com/v4/letter/s/eb8c5e/32.png) [@sadouglas](https://forums.toadworld.com/u/sadouglas)\
**Post date:** [March 12, 2020, 4:36pm UTC](https://forums.toadworld.com/t/date-format-is-different-when-exporting-to-insert-statement/49289/1 "2020-03-12T16:36:30Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 12, 2020, 4:46pm UTC](https://forums.toadworld.com/t/date-format-is-different-when-exporting-to-insert-statement/49289/2 "2020-03-12T16:46:23Z")

</div>

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

NLS parameters has nothing to do with it.

---

<div class="post-metadata">

**Author:** ![sadouglas](https://avatars.discourse-cdn.com/v4/letter/s/eb8c5e/32.png) [@sadouglas](https://forums.toadworld.com/u/sadouglas)\
**Post date:** [March 12, 2020, 4:51pm UTC](https://forums.toadworld.com/t/date-format-is-different-when-exporting-to-insert-statement/49289/3 "2020-03-12T16:51:29Z")

</div>

It's version 12.1.0.22

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 12, 2020, 5:41pm UTC](https://forums.toadworld.com/t/date-format-is-different-when-exporting-to-insert-statement/49289/4 "2020-03-12T17:41:42Z")

</div>

That was fixed in version 12.9.