Toad World® Forums

Default date format in Toad for DB2

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.

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.