How to Change Date Format in Toad For Oracle?

How to Change Date Format in Toad For Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Toad
  • 1 min read

To change the date format in Toad for Oracle follow these steps.

Steps to Change Date Format in Toad For Oracle

  1. In Toad, click on the menu View > Toad Options.
  2. Then an Options window will open.
  3. In the Options window, click on the Data option under Data Grids node.
  4. 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.

Change date format option in Toad for Oracle.

You can now check the results by running the SQL query in Toad.

See also:

This Post Has One Comment

  1. anuj November 24, 2023

    thank you, problem solved.

Comments are closed.