--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;