MS SQL。서식 지정(FORMAT)

서식이 지정된 값 반환

 

FORMAT([데이터], [서식])

 

# 날짜 형식

 

DECLARE @d DATETIME = '10/17/2020'
SELECT FORMAT(@d, 'd', 'en-US') AS 'US English Result'
      ,FORMAT(@d, 'd', 'en-gb') AS 'Great Britain English Result'
      ,FORMAT(@d, 'd', 'de-de') AS 'German Result'
      ,FORMAT(@d, 'd', 'zh-cn') AS 'Simplified Chinese (PRC) Result'
 
SELECT FORMAT(@d, 'D', 'en-US') AS 'US English Result'
      ,FORMAT(@d, 'D', 'en-gb') AS 'Great Britain English Result'
      ,FORMAT(@d, 'D', 'de-de') AS 'German Result'
      ,FORMAT(@d, 'D', 'zh-cn') AS 'Chinese (Simplified PRC) Result'

 

 

# 시간 형식

 

SELECT FORMAT(SYSDATETIME(), N'hh:mm tt') AS Result

SELECT FORMAT(CAST('10:17' AS TIME), N'hh:mm') AS Result       --RETURN NULL
SELECT FORMAT(CAST('10:17' AS TIME), N'hh\:mm') AS Result      --RETURN 10:17

SELECT FORMAT(CAST('10:17' AS DATETIME), N'hh:mm') AS Result

 

 

# 지정 서식

 

DECLARE @d DATETIME = '10/17/2020';  

SELECT FORMAT(@d, 'dd/MM/yyyy', 'en-US') AS 'DateTime Result'  
      ,FORMAT(12345678,'####-####') AS 'Custom Number Result'

 

docs.microsoft.com/ko-kr/sql/t-sql/functions/format-transact-sql?view=sql-server-ver15

FORMAT(Transact-SQL) - SQL Server