Default date format in Toad for DB2

[secarnes]

How can I change the default date format? There is Data Type Formatting in options under Environment/Grid but there is only an option for the DateTime data type. There is not one for the Date or Time formats.

[Jeff_Podlasek]

You can specify a custom date format via the Custom tab as shown below.

The above shows MM-dd-yyyy as my custom DATE format.

At this time - you cannot specify a custom Time format.

I opened issue TDB-3520 to track the request for supporting custom Time formats.

Jeff