[MSSQL] 날짜 형식의 종류

[MSSQL] 날짜 형식의 종류

SELECT   

     CAST('2017-05-08 12:35:29. 1234567 +12:15' AS time(7)) AS 'time'   

    ,CAST('2017-05-08 12:35:29. 1234567 +12:15' AS date) AS 'date'   

    ,CAST('2017-05-08 12:35:29.123' AS smalldatetime) AS   'smalldatetime'   

    ,CAST('2017-05-08 12:35:29.123' AS datetime) AS 'datetime'   

    ,CAST('2017-05-08 12:35:29. 1234567 +12:15' AS datetime2(7)) AS   'datetime2'  

    ,CAST('2017-05-08 12:35:29.1234567 +12:15' AS datetimeoffset(7)) AS   'datetimeoffset';