Script Ouput Default Date Format

Toad for Oracle
1

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.

2

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]

3

Apparently, F5 does not respect session nls timestamp format settings:

alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
alter session set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SS';
alter session set nls_timestamp_tz_format = 'YYYY-MM-DD HH24:MI:SS';

select sysdate from dual;
select systimestamp from dual;

Session altered.
Session altered.
Session altered.

SYSDATE
---------------------
2020-07-31 19:52:30
1 row selected.

SYSTIMESTAMP
----------------------------
07/31/20 19:52:30.284808 +00
1 row selected.

Cheers,
Russ

4

Thanks, I've logged it.

5

Thank you NormTeamT for the explanation.