To change the date format in Toad for Oracle follow these steps.
Steps to Change Date Format in Toad For Oracle
- In Toad, click on the menu View > Toad Options.
- Then an Options window will open.
- In the Options window, click on the Data option under Data Grids node.
- In the Data option tab, you will find Date Format drop-down menu. Select the date format as per your requirement, and you can also select the Time format from the Time Format drop-down and then click on the Apply button and click on OK, as shown in the below image.
You can now check the results by running the SQL query in Toad.