TSQL - 日期格式字串轉換

最近接手前人的系統後，比較常寫 Transact-SQL，常常遇到 傳入各種日期的格式轉換，以下從 Microsoft 中擷取出來的各種日期格式的轉換方式，先筆記起來：

-- ex: 08/09/2018
SELECT Code = 101, [Format] = CONVERT(NVARCHAR, GETDATE(), 101)
-- ex: 2018.08.09
SELECT Code = 102, [Format] = CONVERT(NVARCHAR, GETDATE(), 102)
-- ex: 09/08/2018
SELECT Code = 103, [Format] = CONVERT(NVARCHAR, GETDATE(), 103)
-- ex: 09.08.2018
SELECT Code = 104, [Format] = CONVERT(NVARCHAR, GETDATE(), 104)
-- ex: 09-08-2018
SELECT Code = 105, [Format] = CONVERT(NVARCHAR, GETDATE(), 105)
-- ex: 09 08 2018
SELECT Code = 106, [Format] = CONVERT(NVARCHAR, GETDATE(), 106)
-- ex: 08 09, 2018
SELECT Code = 107, [Format] = CONVERT(NVARCHAR, GETDATE(), 107)
-- ex: 17:55:35
SELECT Code = 108, [Format] = CONVERT(NVARCHAR, GETDATE(), 108)
-- ex: 08  9 2018  5:55:35:147PM
SELECT Code = 109, [Format] = CONVERT(NVARCHAR, GETDATE(), 109)
-- ex: 08-09-2018
SELECT Code = 110, [Format] = CONVERT(NVARCHAR, GETDATE(), 110)
-- ex: 2018/08/09
SELECT Code = 111, [Format] = CONVERT(NVARCHAR, GETDATE(), 111)
-- ex: 20180809
SELECT Code = 112, [Format] = CONVERT(NVARCHAR, GETDATE(), 112)
-- ex: 09 08 2018 17:55:35:147
SELECT Code = 113, [Format] = CONVERT(NVARCHAR, GETDATE(), 113)
-- ex: 17:55:35:147
SELECT Code = 114, [Format] = CONVERT(NVARCHAR, GETDATE(), 114)
-- ex: 2018-08-09 17:55:35
SELECT Code = 120, [Format] = CONVERT(NVARCHAR, GETDATE(), 120)
-- ex: 2018-08-09 17:55:35.147
SELECT Code = 121, [Format] = CONVERT(NVARCHAR, GETDATE(), 121)
-- ex: 2018-08-09T17:55:35.147
SELECT Code = 126, [Format] = CONVERT(NVARCHAR, GETDATE(), 126)
-- ex: 2018-08-09T17:55:35.147
SELECT Code = 127, [Format] = CONVERT(NVARCHAR, GETDATE(), 127)
-- ex: 28 ذو القعدة 1439  5:58:33:403
SELECT Code = 130, [Format] = CONVERT(NVARCHAR, GETDATE(), 130)
-- ex: 28/11/1439  5:55:35:147PM
SELECT Code = 131, [Format] = CONVERT(NVARCHAR, GETDATE(), 131)