Default date format in Toad for DB2

Toad for IBM DB2
1

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.

2

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

DateFormat.png
DateFormat.png762×590 101 KB

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