๐Ÿ“’ Database/Oracle

[ORACLE] ๋งŽ์ด ์“ฐ๋Š” ๋‚ ์งœ ํฌ๋งท ์ •๋ฆฌ

a n u e 2022. 2. 9. 10:37
TO_CHAR(SYSDATE,'YYYYMMDD') 20220209
TO_CHAR(SYSDATE,'YYYY-MM-DD') 2022-02-09
TO_CHAR(SYSDATE,'YYYY/MM/DD') 2022/02/09
TO_CHAR(SYSDATE,'YYYY') 2022
TO_CHAR(SYSDATE,'YY') 22
TO_CHAR(SYSDATE,'MM') 02
TO_CHAR(SYSDATE,'MON') 02์›”
TO_CHAR(SYSDATE,'D') 4 (์ฃผ์ค‘์˜ ์ผ์„ 1~7๋กœ ํ‘œ์‹œ. ์ผ์š”์ผ์€ 1)
TO_CHAR(SYSDATE,'DD') 09
TO_CHAR(SYSDATE,'DAY') ์ˆ˜์š”์ผ
TO_CHAR(SYSDATE,'DY') ์ˆ˜
TO_CHAR(SYSDATE,'DL') 2022๋…„ 02์›” 09์ผ ์ˆ˜์š”์ผ