Will query results derived the insert statement in PLSQL, right-click in the query results interface - derived data - to SQL file, the date format is dd - mm - yyyy, I want to export is yyyy - mm - dd format,

Modify the
The alter system set nls_date_format='yyyy - mm - dd hh24: mi: ss' scope=spfile;
Alter session set nls_date_format='yyyy - mm - dd hh24: mi: ss';
Don't work
Appreciate the great god give directions!

CodePudding user response:

Use the to_char (date field, '- dd yyyy - mm)

CodePudding user response:

PLSQL set inside, the config - NLSoptions, set the format you want