Adjustment of oracle time format

2020-06-03 08:39:41
OfStack

                    select * from V$NLS_PARAMETERS; 

SQL
>
 alter session set NLS_DATE_LANGUAGE = 'SIMPLIFIED CHINESE'; 

Session altered 

SQL
>
 Select to_char(sysdate,'yyyy-Mon-day') from dual; 

TO_CHAR(SYSDATE,'YYYY-MON-DAY' 

------------------------------ 

May 2009- Wednesday

SQL
>
 alter session set NLS_DATE_LANGUAGE='AMERICAN'; 

Session altered 

SQL
>
 Select to_char(sysdate,'yyyy-Mon-day') from dual; 

TO_CHAR(SYSDATE,'YYYY-MON-DAY' 

------------------------------ 

2009-May-wednesday 

SQL
>