MS-SQL 날짜 변환표 (CONVERT)

기준날짜 : 2024년 9월 26일 15시 3분 19.860초

 

구분	쿼리	결과	포맷
0	CONVERT(CHAR(19), DATETIME, 0)	09 26 2024  3:03PM	MM DD YYYY H:MM
1	CONVERT(CHAR(10), DATETIME, 1)	09/26/24	MM/DD/YYYY
2	CONVERT(CHAR(8), DATETIME, 2)	24.09.26	YY.MM.DD
3	CONVERT(CHAR(8), DATETIME, 3)	26/09/24	DD/MM/YY
4	CONVERT(CHAR(8), DATETIME, 4)	26.09.24	DD.MM.YY
5	CONVERT(CHAR(8), DATETIME, 5)	26-09-24	DD-MM-YY
6	CONVERT(CHAR(8), DATETIME, 6)	26 09 24	DD MM YY
7	CONVERT(CHAR(9), DATETIME, 7)	09 26, 24	MM DD, YY
8	CONVERT(CHAR(8), DATETIME, 8)	15:03:19	HH:MM:SS
9	CONVERT(CHAR(26), DATETIME, 9)	09 26 2024  3:03:19:860PM	NN DD YYYY H:MM:SS.MS
10	CONVERT(CHAR(8), DATETIME, 10)	09-26-24	MM-DD-YY
11	CONVERT(CHAR(8), DATETIME, 11)	24/09/26	DD/MM/YY
12	CONVERT(CHAR(6), DATETIME, 12)	240926	YYMMDD
13	CONVERT(CHAR(24), DATETIME, 13)	26 09 2024 15:03:19:860	DD MM YYYY HH:MM:SS.MS
14	CONVERT(CHAR(12), DATETIME, 14)	15:03:19:860	HH:MM:SS.MS
20	CONVERT(CHAR(19), DATETIME, 20)	2024-09-26 15:03:19	YYYY-MM-DD HH:MM:SS
21	CONVERT(CHAR(23), DATETIME, 21)	2024-09-26 15:03:19.860	YYYY-MM-DD HH:MM:SS.MS
22	CONVERT(CHAR(20), DATETIME, 22)	09/26/24  3:03:19 PM	MM/DD/YY H:M:S
23	CONVERT(CHAR(10), DATETIME, 23)	2024-09-26	YYYY-MM-DD
24	CONVERT(CHAR(8), DATETIME, 24)	15:03:19	HH:MM:SS
25	CONVERT(CHAR(23), DATETIME, 25)	2024-09-26 15:03:19.860	YYYY-MM-DD HH:MM:SS.MS
100	CONVERT(CHAR(19), DATETIME, 100)	09 26 2024  3:03PM	MM DD YYYY H:MM
101	CONVERT(CHAR(10), DATETIME, 101)	09/26/2024	MM/DD/YYYY
102	CONVERT(CHAR(10), DATETIME, 102)	2024.09.26	YYYY.MM.DD
103	CONVERT(CHAR(10), DATETIME, 103)	26/09/2024	DD/MM/YYYY
104	CONVERT(CHAR(10), DATETIME, 104)	26.09.2024	DD/MM/YYYY
105	CONVERT(CHAR(10), DATETIME, 105)	26-09-2024	DD-MM-YYYY
106	CONVERT(CHAR(11), DATETIME, 106)	02 01 2000	DD MM YYYY
107	CONVERT(CHAR(12), DATETIME, 107)	09 26, 2024	MM DD, YYYY
108	CONVERT(CHAR(8), DATETIME, 108)	15:03:19	HH:MM:SS
109	CONVERT(CHAR(26), DATETIME, 109)	09 26 2024  3:03:19:860PM	MM DD YYYY H:MM:DD.MS
110	CONVERT(CHAR(10), DATETIME, 110)	09-26-2024	MM-DD-YYYY
111	CONVERT(CHAR(10), DATETIME, 111)	2024/09/26	YYYY/MM/DD
112	CONVERT(CHAR(8), DATETIME, 112)	20240926	YYYYMMDD
113	CONVERT(CHAR(24), DATETIME, 113)	26 09 2024 15:03:19:860	DD MM YYYY HH:MM:DD.MS
114	CONVERT(CHAR(12), DATETIME, 114)	15:03:19:860	HH:MM:DD:MS
120	CONVERT(CHAR(19), DATETIME, 120)	2024-09-26 15:03:19	YYYY-MM-DD HH:MM:SS
121	CONVERT(CHAR(23), DATETIME, 121)	2024-09-26 15:03:19.860	YYYY-MM-DD HH:MM:SS.MS
126	CONVERT(CHAR(23), DATETIME, 126)	2024-09-26T15:03:19.860	YYYY-MM-DDT HH:MM:SS.MS
127	CONVERT(CHAR(23), DATETIME, 127)	2024-09-26T15:03:19.860	YYYY-MM-DDT HH:MM:SS.MS
131	CONVERT(CHAR(25), DATETIME, 131)	23/03/1446  3:03:19:860PM	DD/MM/YYYY H:MM:SS:MS