How to convert JavaScript datetime to MySQL datetime ?
Last Updated :
15 Dec, 2023
To convert a JavaScript Date
object to a MySQL datetime format, you can use the toISOString
method to get the date in ISO format, and then manipulate the string to fit the MySQL datetime format. Given a date in JavaScript DateTime format the task is to convert this time into MySQL DateTime format using JavaScript.
Approach:
Example 1: In this example, the JavaScript DateTime object is converted into MySQL DateTime (UTC format) by using the slice() and replace() method.
Javascript
function GFG_Fun() {
let date = new Date();
console.log( "MySQL datetime - " +
date.toISOString().slice(0, 19).replace( 'T' , ' ' ));
}
GFG_Fun();
|
Output
MySQL datetime - 2023-06-18 03:27:13
Example 2: In this example, time is in IST, the JS datetime is converted to MySQL datetime by using the slice() and replace() method.
Javascript
function GFG_Fun() {
let date = new Date();
console.log( "MySQL datetime - " +
date.toISOString().split( 'T' )[0] + ' '
+ date.toTimeString().split( ' ' )[0]);
}
GFG_Fun();
|
Output
MySQL datetime - 2023-06-18 03:28:31
Share your thoughts in the comments
Please Login to comment...