MSSQL :: date format 날짜 형식들

 

Convert Datetime 과 관련된 것들..

 

Date Format 문법

CONVERT([포맷(크기)], [날짜값], [변환형식])

 

 

Date Format 의 날짜 형식들

SELECT GETDATE()											-- 2024-01-09 05:48:47.190
 
SELECT CONVERT(VARCHAR, GETDATE(), 0)			-- Jan  9 2024  5:48AM
 
SELECT CONVERT(VARCHAR, GETDATE(), 1)			-- 01/09/24
 
SELECT CONVERT(VARCHAR, GETDATE(), 2)			-- 24.01.09
 
SELECT CONVERT(VARCHAR, GETDATE(), 3)			-- 09/01/24
 
SELECT CONVERT(VARCHAR, GETDATE(), 4)			-- 09.01.24
 
SELECT CONVERT(VARCHAR, GETDATE(), 5)			-- 09-01-24
 
SELECT CONVERT(VARCHAR, GETDATE(), 6)			-- 09 Jan 24
 
SELECT CONVERT(VARCHAR, GETDATE(), 7)			-- Jan 09, 24
 
SELECT CONVERT(VARCHAR, GETDATE(), 8)			-- 05:51:54
 
SELECT CONVERT(VARCHAR, GETDATE(), 9)			-- Jan  9 2024  5:52:00:223AM
 
SELECT CONVERT(VARCHAR, GETDATE(), 10)		-- 01-09-24
 
SELECT CONVERT(VARCHAR, GETDATE(), 11)		-- 24/01/09
 
SELECT CONVERT(VARCHAR, GETDATE(), 12)		-- 240109
 
SELECT CONVERT(VARCHAR, GETDATE(), 13)		-- 09 Jan 2024 05:52:32:353
 
SELECT CONVERT(VARCHAR, GETDATE(), 14)		-- 05:52:49:243
 
SELECT CONVERT(VARCHAR, GETDATE(), 20)		-- 2024-01-09 05:52:56
 
SELECT CONVERT(VARCHAR, GETDATE(), 21)		-- 2024-01-09 05:53:01.340
 
SELECT CONVERT(VARCHAR, GETDATE(), 22)		-- 01/09/24  5:53:08 AM
 
SELECT CONVERT(VARCHAR, GETDATE(), 23)		-- 2024-01-09
 
SELECT CONVERT(VARCHAR, GETDATE(), 24)		-- 05:53:20
 
SELECT CONVERT(VARCHAR, GETDATE(), 25)		-- 2024-01-09 05:53:25.427
 
SELECT CONVERT(VARCHAR, GETDATE(), 100)		-- Jan  9 2024  5:53AM
 
SELECT CONVERT(VARCHAR, GETDATE(), 101)		-- 01/09/2024
 
SELECT CONVERT(VARCHAR, GETDATE(), 102)		-- 2024.01.09

SELECT CONVERT(VARCHAR, GETDATE(), 104)		-- 09.01.2024
 
SELECT CONVERT(VARCHAR, GETDATE(), 105)		-- 09-01-2024
 
SELECT CONVERT(VARCHAR, GETDATE(), 106)		-- 09 Jan 2024
 
SELECT CONVERT(VARCHAR, GETDATE(), 107)		-- Jan 09, 2024
 
SELECT CONVERT(VARCHAR, GETDATE(), 108)		-- 05:54:15
 
SELECT CONVERT(VARCHAR, GETDATE(), 109)		-- Jan  9 2024  5:54:22:753AM
 
SELECT CONVERT(VARCHAR, GETDATE(), 110)		-- 01-09-2024
 
SELECT CONVERT(VARCHAR, GETDATE(), 111)		-- 2024/01/09
 
SELECT CONVERT(VARCHAR, GETDATE(), 112)		-- 20240109
 
SELECT CONVERT(VARCHAR, GETDATE(), 113)		-- 09 Jan 2024 05:54:45:377
 
SELECT CONVERT(VARCHAR, GETDATE(), 114)		-- 05:54:50:983
 
SELECT CONVERT(VARCHAR, GETDATE(), 120)		-- 2024-01-09 05:54:56
 
SELECT CONVERT(VARCHAR, GETDATE(), 121)		-- 2024-01-09 05:55:01.283
 
SELECT CONVERT(VARCHAR, GETDATE(), 126)		-- 2024-01-09T05:55:06.660
 
SELECT CONVERT(VARCHAR, GETDATE(), 127)		-- 2024-01-09T05:55:11.133
 
SELECT CONVERT(VARCHAR, GETDATE(), 130)		-- 28 ????? ??????? 1445  5:55:35
 
SELECT CONVERT(VARCHAR, GETDATE(), 131)		-- 28/06/1445  5:55:40:630AM

 

 

datetime 을 원하는 양식으로 select 하기에 좋은 문법.

다 외우기는 힘들테니 메모하고자 정리.