Open In App
Related Articles

How to convert JavaScript datetime to MySQL datetime ?

Improve Article
Improve
Save Article
Save
Like Article
Like

Given a date in JavaScript DateTime format and 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 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: This is same as previous example but with a different approach and time is in IST, the JS datetime is converted to MySQL datetime by using 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
Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!

Last Updated : 20 Jun, 2023
Like Article
Save Article
Similar Reads
Related Tutorials