Toad World® Forums

Script Ouput Default Date Format

Hello,

How does one change the default date format displayed in the Script Output window (Output tab or Grid tab)?

Tried using "View | Toad Options ... | Data Grids | Data | Date Format", but it didn't change the format in the Script Output window.

Using Toad for Oracle 13.2 on Windows 10.

Thanks in advance.

If you F5 to run as a script, the behaviour is as identical to that of
SQL*Plus as is humanly possible, so the default date format is taken
from NLS_DATE_FORMAT for your session. Hence the dates will be seen in
whatever has been defined - or in the database's own default setting
(DD-MON-YY I suspect.).

With F9 the dates are displayed in the format defined in VIEW->TOAD
OPTIONS->DATA GRIDS->DATA then Date Format and Time Format. This is how
dates are DISPLAYED. To enter a date you should still be wrapping
strings in TO_DATE() with the correct format for the input string.

HTH

Cheers,
Norm. [TeamT]