위키
포럼
도구
바뀐글
랜덤

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

잔글 (봇: 자동으로 텍스트 교체 (-</source> +</syntaxhighlight>, -<source +<syntaxhighlight ))
15번째 줄: 15번째 줄:
console.log( date );
console.log( date );
// Fri Nov 17 2017 00:31:40 GMT+0900 (대한민국 표준시)
// Fri Nov 17 2017 00:31:40 GMT+0900 (대한민국 표준시)
</syntaxhighlight>
==SQL==
[[분류: SQL]]
===MySQL===
[[분류: MySQL]]
<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))
</syntaxhighlight>
</syntaxhighlight>

2021년 4월 3일 (토) 14:55 판

YYYYMMDDHHMMSS to datetime

1 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

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

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))
원본 주소 "https://zetawiki.com/w/index.php?title=YYYYMMDDHHMMSS_to_datetime&oldid=734611"
문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}