Help to take a look at this problem-CodePudding

Oracle TO_CHAR (sysdate, 'yyyy/mm/dd hh24: mi: ss'), the current time into characters, how to appear '2018/1/31 2:21:19 Wednesday afternoon, this format,
The select TO_CHAR (sysdate, 'yyyy/mm/dd hh24: mi: ss') from dual; Query when no problem, 2018/01/31 15:01:39

CodePudding user response:

The select TO_CHAR (sysdate, 'yyyy/RM/dd DY TS') from dual;

CodePudding user response:

The select TO_CHAR (sysdate, 'yyyy/mm/dd DY TS') from dual;

CodePudding user response:

If you want to show Chinese, then # 2 building in the implementation of the SQL, you can set the first:
Alter session set NLS_DATE_LANGUAGE="SIMPLIFIED CHINESE".