mssqlserver:basic

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- mssqlserver:basic [2020/08/24 17:16]
kwon37xi [String to DATETIME]
+++ mssqlserver:basic [2020/08/24 17:16] (현재)
kwon37xi [String to DATETIME]
@@ 줄 134: / 줄 134: @@
 DECLARE @d NVARCHAR(14)='20170920185147';
-SELECT DATETIMEFROMPARTS (LEFT(@d, 4),  SUBSTRING(@d, 5,2), SUBSTRING(@d,7 ,2), SUBSTRING(@d, 9, 2) , SUBSTRING(@d, 11, 2), RIGHT(@d, 2), 0) as "with_var",
+SELECT
-DATETIMEFROMPARTS (LEFT('20170920185147', 4),  SUBSTRING('20170920185147', 5,2), SUBSTRING('20170920185147',7 ,2), SUBSTRING('20170920185147', 9, 2) , SUBSTRING('20170920185147', 11, 2), RIGHT('20170920185147', 2), 0) as "with_literal",
+   DATETIMEFROMPARTS (LEFT(@d, 4),  SUBSTRING(@d, 5,2), SUBSTRING(@d,7 ,2), SUBSTRING(@d, 9, 2) , SUBSTRING(@d, 11, 2), RIGHT(@d, 2), 0) as "with_var",
-DATETIME2FROMPARTS (LEFT('20170920185147', 4),  SUBSTRING('20170920185147', 5,2), SUBSTRING('20170920185147',7 ,2), SUBSTRING('20170920185147', 9, 2) , SUBSTRING('20170920185147', 11, 2), RIGHT('20170920185147', 2), 0, 0) as "dt2"
+   DATETIMEFROMPARTS (LEFT('20170920185147', 4),  SUBSTRING('20170920185147', 5,2), SUBSTRING('20170920185147',7 ,2), SUBSTRING('20170920185147', 9, 2) , SUBSTRING('20170920185147', 11, 2), RIGHT('20170920185147', 2), 0) as "with_literal",
+   DATETIME2FROMPARTS (LEFT('20170920185147', 4),  SUBSTRING('20170920185147', 5,2), SUBSTRING('20170920185147',7 ,2), SUBSTRING('20170920185147', 9, 2) , SUBSTRING('20170920185147', 11, 2), RIGHT('20170920185147', 2), 0, 0) as "dt2"
 ;
 </code>

mssqlserver/basic.1598256980.txt.gz · 마지막으로 수정됨: 2020/08/24 17:16 저자 kwon37xi