Four ways to modify the ORACLE-NLS_DATE_FORMAT time format

Four ways to modify the ORACLE-NLS_DATE_FORMAT time format change the display of the time display format in ORACLE-NLS_DATE_FORMAT:

1. You can specify (LINUX) in user environment variables ). Add the following sentence to your. bash_profile: export NLS_LANG = AMERICAN --- Note that this sentence must be specified, otherwise the next sentence will not take effect. Export NLS_DATE_FORMAT = 'yyyy/mm/dd hh24: mi: ss' 2. in SQLPLUS glogin. in the SQL file, add the following statement: alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; 3. directly modify the date format of the current session: alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; 4. to modify the database parameters, You need to restart the database to take effect. SQL> alter system set nls_date_format = 'yyyy-mm-dd hh24: mi: ss' scope = spfile;