MSSQL GETDATE() CONVERT 변환

MSSQL GETDATE()  CONVERT 변환

▶CONVERT 

getdate()를  varchar로 convert 할때, 세번째 인자에 숫자를 넣는데

어디까지 있나 궁금하여 한번 다 돌려보았다

2019년 02월 22일 기준

SELECT CONVERT(VARCHAR, getdate(), 1)  -- 02/22/19
SELECT CONVERT(VARCHAR, getdate(), 2)  -- 19.02.22
SELECT CONVERT(VARCHAR, getdate(), 3)  -- 22/02/19
SELECT CONVERT(VARCHAR, getdate(), 4)  -- 22.02.19
SELECT CONVERT(VARCHAR, getdate(), 5)  -- 22-02-19
SELECT CONVERT(VARCHAR, getdate(), 6)  -- 22 02 19
SELECT CONVERT(VARCHAR, getdate(), 7)  -- 02 22, 19
SELECT CONVERT(VARCHAR, getdate(), 8)  -- 11:55:03
SELECT CONVERT(VARCHAR, getdate(), 9)  -- 02 22 2019 11:55:03:633AM
SELECT CONVERT(VARCHAR, getdate(), 10)  -- 02-22-19
SELECT CONVERT(VARCHAR, getdate(), 11)  -- 19/02/22
SELECT CONVERT(VARCHAR, getdate(), 12)  -- 190222
SELECT CONVERT(VARCHAR, getdate(), 13)  -- 22 02 2019 11:57:22:510
SELECT CONVERT(VARCHAR, getdate(), 14)  -- 11:57:22:510
SELECT CONVERT(VARCHAR, getdate(), 20)  -- 2019-02-22 11:57:22
SELECT CONVERT(VARCHAR, getdate(), 21)  -- 2019-02-22 11:58:15.467
SELECT CONVERT(VARCHAR, getdate(), 22)  -- 02/22/19 11:58:15 AM
SELECT CONVERT(VARCHAR, getdate(), 23)  -- 2019-02-22
SELECT CONVERT(VARCHAR, getdate(), 24)  -- 11:58:15
SELECT CONVERT(VARCHAR, getdate(), 25)  -- 2019-02-22 11:58:15.467
SELECT CONVERT(VARCHAR, getdate(), 100) -- 02 22 2019  4:24PM
SELECT CONVERT(VARCHAR, getdate(), 101) -- 02/22/2019
SELECT CONVERT(VARCHAR, getdate(), 102) -- 2019.02.22
SELECT CONVERT(VARCHAR, getdate(), 103) -- 22/02/2019
SELECT CONVERT(VARCHAR, getdate(), 104) -- 22.02.2019
SELECT CONVERT(VARCHAR, getdate(), 105) -- 22-02-2019
SELECT CONVERT(VARCHAR, getdate(), 106) -- 22 02 2019
SELECT CONVERT(VARCHAR, getdate(), 107) -- 02 22, 2019
SELECT CONVERT(VARCHAR, getdate(), 108) -- 16:27:04
SELECT CONVERT(VARCHAR, getdate(), 109) -- 02 22 2019  4:27:04:687PM
SELECT CONVERT(VARCHAR, getdate(), 110) -- 02-22-2019
SELECT CONVERT(VARCHAR, getdate(), 111) -- 2019/02/22
SELECT CONVERT(VARCHAR, getdate(), 112) -- 20190222
SELECT CONVERT(VARCHAR, getdate(), 113) -- 22 02 2019 16:27:04:687
SELECT CONVERT(VARCHAR, getdate(), 114) -- 16:27:04:687
SELECT CONVERT(VARCHAR, getdate(), 120) -- 2019-02-22 16:27:46
SELECT CONVERT(VARCHAR(11), getdate()-2, 120) + '11:00:00'-- 2019-02-20 11:00:00
SELECT CONVERT(VARCHAR, getdate(), 121) -- 2019-02-22 16:27:46.370
SELECT CONVERT(VARCHAR, getdate(), 126) -- 2019-02-22T16:27:46.370
SELECT CONVERT(VARCHAR, getdate(), 127) -- 2019-02-22T16:27:46.370
SELECT CONVERT(VARCHAR, getdate(), 130) -- 17 ????? ??????? 1440  4:27:46
SELECT CONVERT(VARCHAR, getdate(), 131) -- 17/06/1440  4:27:46:383PM
SELECT SUBSTRING(CONVERT(VARCHAR(12), GETDATE(), 112),1,6) -- 201902