5일차 # 3-17: Working with Dates

SQL> alter session set nls_language = american;

SQL> alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';

--> format elements: YYYY, MM, DD, HH24, MI, SS 등등

SQL> select * from emp;

SQL> select sysdate from dual;

SQL> alter session set nls_date_format='DD/MON-RR HH:MI [AM]';

SQL> select * from emp;

SQL> select sysdate from dual;

SQL> alter session set nls_date_format='DD-MONTH-RR HH:MI:SS.SSSSS     PM';

SQL> select sysdate from dual;

SQL> alter session set nls_date_format='DD-month-rr';

SQL> select sysdate from dual;

SQL> alter session set nls_date_format='DD-mon-RR';

SQL> select sysdate from dual;