show parameters NLS_DATE_FORMAT;
show parameters nls_date_language;
SELECT
TO_CHAR(sysdate,'MM/DD/YYYY HH:MI AM','NLS_DATE_LANGUAGE = ''SIMPLIFIED CHINESE''') Chn,
TO_CHAR(sysdate,'MM/DD/YYYY HH:MI AM','NLS_DATE_LANGUAGE = American') Ame,
TO_CHAR(sysdate,'MM/DD/YYYY HH:MI AM','NLS_DATE_LANGUAGE = Japanese') Jap,
TO_CHAR(sysdate,'MM/DD/YYYY HH:MI AM','NLS_DATE_LANGUAGE = english') Eng
FROM DUAL;