substring1 210531_2 CAST :DATA 형변환 SELECT CAST('2020-10-19 12:35:29.123' AS DATETIME) AS 'DATETIME' SELECT CAST('2020-10-19 12:35:29.1234567 +12:15' AS DATETIME2(7)) AS 'DATETIME2' SELECT CAST('2020-10-19 12:35:29.1234567 +12:15' AS DATE) AS 'DATE' SELECT CAST('2020-10-19 12:35:29.1234567 +12:15' AS TIME(7)) AS 'TIME' SELECT CAST('2020-10-19 12:35:29.1234567 +12:15' AS DATETIMEOFFSET(7)) AS 'DATETIMEOFFSET' SELECT .. 2021. 5. 31. 이전 1 다음
