# Date grid format ignored. 12.\*

**URL:** <https://forums.toadworld.com/t/date-grid-format-ignored-12/34691>\
**Category:** Toad for Oracle - Beta\
**Created:** [December 16, 2015, 11:51pm UTC](https://forums.toadworld.com/t/date-grid-format-ignored-12/34691 "2015-12-16T23:51:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![fisher\_359](https://avatars.discourse-cdn.com/v4/letter/f/f08c70/32.png) [@fisher\_359](https://forums.toadworld.com/u/fisher_359)\
**Post date:** [December 16, 2015, 11:51pm UTC](https://forums.toadworld.com/t/date-grid-format-ignored-12/34691/1 "2015-12-16T23:51:18Z")

</div>

There seem to quite q few places where date format is not being applied.

Schedule\_job : Info Tab (start date, last start date next run date)  
Run log (log date, required start date, actual start date)

Any place where toad makes a conversion, it uses different format :

for example TO\_DATE(‘12/16/2015 16:59:00’, ‘MM/DD/YYYY HH24:MI:SS’),

that leads to odd situation where selecting queue\_table I see some columns in my predefined date/time format,

but payload is containing bunch of expressions like one above for each of the dates.

The same applies to export data set to insert statement

Is it possible to make it consistent and use the same setting or provide new one for specific information if necessary.

---

<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:** [December 17, 2015, 10:57am UTC](https://forums.toadworld.com/t/date-grid-format-ignored-12/34691/2 "2015-12-17T10:57:07Z")

</div>

Yeah, I’ll take a look at these.

---

<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:** [December 17, 2015, 12:44pm UTC](https://forums.toadworld.com/t/date-grid-format-ignored-12/34691/3 "2015-12-17T12:44:07Z")

</div>

I'm not sure what you mean by this:

> selecting queue\_table I see some columns in my predefined date/time format,

> but payload is containing bunch of expressions like one above for each of the dates.

could you give me a screen shot?

---

<div class="post-metadata">

**Author:** ![fisher\_359](https://avatars.discourse-cdn.com/v4/letter/f/f08c70/32.png) [@fisher\_359](https://forums.toadworld.com/u/fisher_359)\
**Post date:** [December 17, 2015, 12:52pm UTC](https://forums.toadworld.com/t/date-grid-format-ignored-12/34691/4 "2015-12-17T12:52:26Z")

</div>

There it is.

On 2015-12-17 21:45, John Dorlon wrote:

> _RE: Date grid format ignored. 12._

> -

> 

> Reply by John Dorlon

> 

> I'm not sure what you mean by this:

> 

> > selecting queue\_table I see some columns in my predefined date/time

> format,

> 

> > but payload is containing bunch of expressions like one above for

> each of the dates.

> 

> could you give me a screen shot?

> 

> To reply, please reply-all to this email.

> 

> Stop receiving emails

> 

> on this subject.

> Or Unsubscribe from Toad for Oracle - Beta

> 

> notifications altogether.

> Toad for Oracle - Beta Discussion Forum

> 

> Flag

> 

> this post as spam/abuse.

>

---

<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:** [December 18, 2015, 6:55am UTC](https://forums.toadworld.com/t/date-grid-format-ignored-12/34691/5 "2015-12-18T06:55:51Z")

</div>

Ok, check it next beta. I got the places you mentioned. If there are others, let me know.