RDBMS/Oracle
[Oracle] 분기 관련 날짜 데이터 출력 - TO_CHAR(), TRUNC()
워터파슬리
2023. 8. 31. 16:17
728x90
반응형
SELECT SYSDATE
,TO_CHAR(SYSDATE, ‘Q’) - 1 AS “전분기”
,ADD_MONTHS(TRUNC(SYSDATE), ‘Q’,- 3) AS “전분기첫일”
,TRUNC(SYSDATE, ‘Q’) - 1 AS “전분기막일”
,TO_CHAR(SYSDATE, ‘Q’) AS “현분기“
,TRUNC(SYSDATE, ‘Q’) AS “현분기첫일”
,ADD_MONTHS(SYSDATE, ‘Q’, 3) - 1 AS “현분기막일”
FROM dual
;
728x90
반응형