📒 Database/Mssql
[MSSQL] 많이 쓰는 날짜 포맷 정리
a n u e
2022. 2. 9. 10:22
| CONVERT(CHAR(8), DATETIME, 8) | 13:14:15 | HH:MM:SS |
| CONVERT(CHAR(19), DATETIME, 20) | 2022-02-09 13:14:15 | YYYY-MM-DD HH:MM:SS |
| CONVERT(CHAR(23), DATETIME, 21) |
2022-02-09 13:14:15.678 | YYYY-MM-DD HH:MM:SS.MS |
| CONVERT(CHAR(10), DATETIME, 23) |
2022-02-09 | YYYY-MM-DD |
| CONVERT(CHAR(23), DATETIME, 25) |
2022-02-09 13:14:15.678 | YYYY-MM-DD HH:MM:SS.MS |
| CONVERT(CHAR(10), DATETIME, 111) |
2022/02/09 | YYYY/MM/DD |
| CONVERT(CHAR(8), DATETIME, 112) |
20220209 | YYYYMMDD |
| CONVERT(CHAR(19), DATETIME, 120) |
2022-02-09 13:14:15 | YYYY-MM-DD HH:MM:SS |