"YYYYMMDDHHMMSS to datetime"의 두 판 사이의 차이

2023년 5월 17일 (수) 12:48 기준 최신판

YYYYMMDDHHMMSS to datetime

1 JavaScript[ | ]

자바스크립트 YYYYMMDDHHMMSS to datetime 문서를 참고하십시오.

var str = "20171117003140";
var dt = str.replace(/^(\d{4})(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$/, '$1-$2-$3 $4:$5:$6');
console.log( dt );
// 2017-11-17 00:31:40

var str = "20171117003140";
var date = new Date(str.replace(/^(\d{4})(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$/, '$1-$2-$3 $4:$5:$6'));
console.log( date );
// Fri Nov 17 2017 00:31:40 GMT+0900 (대한민국 표준시)

2 SQL[ | ]

2.1 MySQL[ | ]

MySQL YYYYMMDDHHMMSS to datetime 문서를 참고하십시오.

SELECT REGEXP_REPLACE("20171117003140", '([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})', '\\1-\\2-\\3 \\4:\\5:\\6')
-- 2017-11-17 00:31:40

SET @x="20171117003140";
SELECT CONCAT(SUBSTRING(@x,1,4),"-",SUBSTRING(@x,5,2),"-",SUBSTRING(@x,7,2)," ",SUBSTRING(@x,9,2),":",SUBSTRING(@x,11,2),":",SUBSTRING(@x,13,2))
-- 2017-11-17 00:31:40

2.2 Oracle[ | ]

Oracle YYYYMMDDHHMMSS to datetime 문서를 참고하십시오.

SELECT TO_DATE('20220517124700', 'YYYYMMDDHH24MISS') FROM DUAL;

@@ 4번째 줄: / 4번째 줄: @@
 ==JavaScript==
 [[분류: JavaScript]]
-<source lang='JavaScript'>
+{{참고|자바스크립트 YYYYMMDDHHMMSS to datetime}}
+<syntaxhighlight lang='JavaScript'>
 var str = "20171117003140";
 var dt = str.replace(/^(\d{4})(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$/, '$1-$2-$3 $4:$5:$6');
 console.log( dt );
 // 2017-11-17 00:31:40
-</source>
+</syntaxhighlight>
-<source lang='JavaScript'>
+<syntaxhighlight lang='JavaScript'>
 var str = "20171117003140";
 var date = new Date(str.replace(/^(\d{4})(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$/, '$1-$2-$3 $4:$5:$6'));
 console.log( date );
 // Fri Nov 17 2017 00:31:40 GMT+0900 (대한민국 표준시)
-</source>
+</syntaxhighlight>
+==SQL==
+[[분류: SQL]]
+===MySQL===
+[[분류: MySQL]]
+{{참고|MySQL YYYYMMDDHHMMSS to datetime}}
+<syntaxhighlight lang='mysql'>
+SELECT REGEXP_REPLACE("20171117003140", '([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})', '\\1-\\2-\\3 \\4:\\5:\\6')
+-- 2017-11-17 00:31:40
+</syntaxhighlight>
+<syntaxhighlight lang='mysql'>
+SET @x="20171117003140";
+SELECT CONCAT(SUBSTRING(@x,1,4),"-",SUBSTRING(@x,5,2),"-",SUBSTRING(@x,7,2)," ",SUBSTRING(@x,9,2),":",SUBSTRING(@x,11,2),":",SUBSTRING(@x,13,2))
+-- 2017-11-17 00:31:40
+</syntaxhighlight>
+===Oracle===
+[[분류: Oracle]]
+{{참고|Oracle YYYYMMDDHHMMSS to datetime}}
+<syntaxhighlight lang='sql'>
+SELECT TO_DATE('20220517124700', 'YYYYMMDDHH24MISS') FROM DUAL;
+</syntaxhighlight>