英文: SELECT TO_CHAR(sysdate, 'MM/DD/YYYY HH:MI AM', 'NLS_DATE_LANGUAGE = American') FROM DUAL 日文: SELECT TO_CHAR(sysdate, 'MM/DD/YYYY HH:MI AM', 'NLS_DATE_LANGUAGE = Japanese') FROM DUAL 中文:(特别注意NLS_DATE_LANGUAGE多个单引号) SELECT TO_CHAR(sysdate, 'MM/DD/YYYY HH:MI AM', 'NLS_DATE_LANGUAGE = ''SIMPLIFIED CHINESE''') FROM DUAL |