How to convert MySQL DATETIME value to JSON format in JavaScript?

To convert, use JSON.stringify(). Following is the code to convert MySQL DATETIME value to JSON format in JavaScript −

<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>

The screenshot of the code is as follows −

This will produce the following output −

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

The snapshot of the output is as follows −

AmitDiwan

Published on 07-Oct-2019 10:48:12

• Related Questions & Answers
• Convert JSON to another JSON format with recursion JavaScript
• How to convert string to 24-hour datetime format in MySQL?
• How to convert Python date in JSON format?
• Adding a day to a DATETIME format value in MySQL?
• How to use MySQL FROM_UNIXTIME() function to return datetime value in numeric format?
• Convert DateTime Value into String in MySQL?
• How to format JSON string in JavaScript?
• How to convert C# DateTime to “YYYYMMDDHHMMSS” format?
• Add10 minutes to MySQL datetime format?
• How to convert timestamp to datetime in MySQL?
• How to convert JSON text to JavaScript JSON object?
• How to convert JSON object to Hashtable format using PowerShell?
• Convert INT to DATETIME in MySQL?
• How to convert MySQL datetime to Unix timestamp?
• How to convert DateTime to a number in MySQL?