I believe that’s what one might call the plain Oracle date format.
In Oracle, date is controlled on 3 levels:
You can query their values:
select * from nls_database_parameters where parameter = ‘NLS_DATE_FORMAT’;
select * from nls_instance_parameters where parameter = ‘NLS_DATE_FORMAT’;
select * from nls_session_parameters where parameter = ‘NLS_DATE_FORMAT’;
They have influence in the mentioned order. So this means if you change your session parameters it will be final and let’s say only important for you and your sql statements.
Session parameter is changed with command:
EXECUTE IMMEDIATE ‘alter session set nls_date_format=“yyyy-mm-dd hh24:mi:ss”’;
is one of many Oracle date formats you would like to have.
If you cannot change session parameter in a way to run SQL command before, what seems to be your case, then it should be define “from outside”. One of ways to achieve that in Windows-is registry. Look in Windows registry key:
is definition of your ORACLE_HOME (depend of your Oracle client installation).
Add/change NLS_DATE_FORMAT (SZ string value) to have desired date format. Example:
After that restart Toad and that date will be default for all DATE actions, except Toad grid, whose value are additionally controlled through Toad options.
Keep in mind that registry influence all software on your workstation which use definition from that Oracle home.
I hope this helps.