SELECT
TO_CHAR(SYSDATE,'YYYY-MM-DD') ||
CASE
WHEN TO_CHAR(SYSDATE,'D') ='1' THEN '(日)'
WHEN TO_CHAR(SYSDATE,'D') ='2' THEN '(一)'
WHEN TO_CHAR(SYSDATE,'D') ='3' THEN '(二)'
WHEN TO_CHAR(SYSDATE,'D') ='4' THEN '(三)'
WHEN TO_CHAR(SYSDATE,'D') ='5' THEN '(四)'
WHEN TO_CHAR(SYSDATE,'D') ='6' THEN '(五)'
WHEN TO_CHAR(SYSDATE,'D') ='7' THEN '(六)'
END WEEK
FROM DUAL
TO_CHAR(SYSDATE,'YYYY-MM-DD') ||
CASE
WHEN TO_CHAR(SYSDATE,'D') ='1' THEN '(日)'
WHEN TO_CHAR(SYSDATE,'D') ='2' THEN '(一)'
WHEN TO_CHAR(SYSDATE,'D') ='3' THEN '(二)'
WHEN TO_CHAR(SYSDATE,'D') ='4' THEN '(三)'
WHEN TO_CHAR(SYSDATE,'D') ='5' THEN '(四)'
WHEN TO_CHAR(SYSDATE,'D') ='6' THEN '(五)'
WHEN TO_CHAR(SYSDATE,'D') ='7' THEN '(六)'
END WEEK
FROM DUAL