日期格式转换

--1.  

SQL> SELECT TO_CHAR(TRUNC(SYSDATE) + 0.99999
  2                ,'yyyymmdd hh24:mi:ss')
  3    FROM DUAL
  4  /
 
TO_CHAR(TRUNC(SYSDATE)+0.99999
------------------------------
20111115 23:59:59

 

--2.
ALTER SESSION SET nls_date_language ='SIMPLIFIED CHINESE';

SELECT TO_CHAR(SYSDATE
              ,'DD-MON-YYYY')
  FROM DUAL;

ALTER SESSION SET nls_date_language ='AMERICAN';

SELECT TO_CHAR(SYSDATE
              ,'DD-MON-YYYY')
  FROM DUAL;

 

  SELECT TO_DATE('12月-11'
              ,'MON-YY'
              ,'NLS_DATE_LANGUAGE = ''SIMPLIFIED CHINESE''')
  FROM DUAL;

  SELECT TO_DATE('Dec-11'
              ,'MON-YY'
              ,'NLS_DATE_LANGUAGE = AMERICAN')
  FROM DUAL;