months_between 1
[Oracle/SQL] ๋‚ ์งœํ•จ์ˆ˜ - SYSDATE, NEXT_DAY, LAST_DAY ๋“ฑ

- ์˜ค๋ผํด์—์„œ ๋‚ ์งœ๋ฅผ ์ €์žฅ ๋ฐ์ดํ„ฐํ˜• : DATE, TIMESTAMP 1. SYSDATE - ์˜ค๋ผํด์ด ์„ค์น˜๋œ ์ปดํ“จํ„ฐ์˜ ์‹œ์Šคํ…œ ์‹œ๊ฐ„์„ ์•Œ๋ ค์ค€๋‹ค. --SYSDATE ์˜ˆ์‹œ) SELECT SYSDATE FROM DUAL; -- ์˜ค๋Š˜ ๋‚ ์งœ ์ถœ๋ ฅ SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') FROM DUAL; -- ํ˜„์žฌ ์›”-์ผ-๋…„๋„ ์‹œ๊ฐ„:๋ถ„:์ดˆ ์ถœ๋ ฅ --SYSDATE ์—ฐ์‚ฐ ์˜ˆ์‹œ) SELECT SYSDATE+1 FROM DUAL; -- ๋‚ด์ผ ๋‚ ์งœ ์ถœ๋ ฅ SELECT TO_CHAR(SYSDATE-30, 'MM-DD-YYYY HH24:MI:SS') FROM DUAL; -- 30์ผ ์ „ ์ถœ๋ ฅ SELECT TO_CHAR(SYSDATE-8/24, 'MM-DD-YYYY HH24:MI:SS'..
Programming/Database(Oracle, SQL) 2020.02.02
1
๋”๋ณด๊ธฐ
๋ฐ˜์‘ํ˜•

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”