แปลง MySQL DATETIME เป็น JSON Format ใน JavaScript

ใช้ JSON.stringify() แปลง โค้ดแปลง MySQL DATETIME เป็น JSON format:

<script> var mySQLDateTime = new Date("Fri Sep 06 2019 22 -54 -48 "); var yearValue = mySQLDateTime.getFullYear(); var dateValue = mySQLDateTime.getDate(); var monthValue=mySQLDateTime.getMonth(); var hour=mySQLDateTime.getHours(); var minutes=mySQLDateTime.getMinutes(); var second=mySQLDateTime.getSeconds(); jsonObject={"year" -yearValue,"month" :monthValue,"DateValue" :dateValue,"Hour" :hour ,"Minutes" :minutes,"Second" :second}; var dateJsonObject = JSON.stringify(jsonObject); document.write(dateJsonObject); </script>

ผลลัพธ์:

{"year" :2019,"month" :8,"DateValue" :6,"Hour" :22,"Minutes" :54,"Second" :48}