As shown in figure... The date format very strange... I want to change it to a common format, but why after the update or such things?
Before you update is such...

CodePudding user response:

The select set the display format before:
Alter session set nls_date_format='yyyy - mm - dd hh24: mi: ss';
Or you select, with the to_char function format hiredate field
The most important thing is: value of the current display does not affect your date field, it is the result you want,

CodePudding user response:

Well, modify the next session or the system date format parameter can be:
Alter session set nls_date_format=... ;
Or the alter system set nls_date_format=... ;
Upstairs positive solution,