컴방/SQL
MSSQL 날짜 변환 CONVERT DATETIME
개발자룽
2021. 3. 11. 13:10
CONVERT(CHAR(10), DATETIME, 23) 2021-01-02 YYYY-MM-DD
CONVERT(CHAR(23), DATETIME, 21) 2021-01-02 13:14:15.678 YYYY-MM-DD HH:MM:SS.MS
CONVERT(CHAR(8), DATETIME, 112) 20210102 YYYYMMDD