Oracle/SQL Fundamentals I
5일차 # 3-17: Working with Dates
Bohemian life
2012. 4. 9. 23:00
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;