| 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 |