무회blog

SELECT TO_CHAR(TO_DATE('20221201'),'W') AS 월_WEEK FROM DUAL; -- 월주차 SELECT TO_CHAR(TO_DATE('20221125'),'W') AS 월_WEEK FROM DUAL; -- 월주차 select * from nls_session_parameters; -- 한글 설정 값 select to_char(TO_DATE('20221201'), 'day') from dual ; -- 목요일 select to_char(TO_DATE('20221201'), 'dy') from dual ; -- 목 select to_char(TO_DATE('20221201'), 'd') from dual ; -- (1:일, 2:월, 3:화, 4:수, 5:목, 6:금, 7:토) ..