๐ 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์ผ ์์์ผ |