How to convert JavaScript datetime to MySQL datetime ?

Last Updated : 28 Jun, 2019

Given a date in JavaScript DateTime format and the task is to convert this time into MySQL DateTime format using JavaScript.

Approach:

Use date.toISOString() function to convert the date object into string ISO format i.e. YYYY-MM-DDTHH:mm:ss.sssZ or ±YYYYYY-MM-DDTHH:mm:ss.sssZ format.
Use slice() method to extract the part of a string.
Use replace() method to replace the ‘T’ character with space ‘ ‘.

Example 1: In this example, the JavaScript datetime object is converted into MySQL datetime (UTC format) by using slice() and replace() method.

<!DOCTYPE HTML> 
<html> 
    <head> 
        <title> 
            How to convert JavaScript datetime
            to MySQL datetime ?
        </title>
    </head> 
      
    <body style = "text-align:center;"> 
          
        <h1 style = "color:green;" > 
            GeeksForGeeks
        </h1>
          
        <p id = "GFG_UP" style =
            "font-size: 19px; font-weight: bold;">
        </p>
          
        <button onclick = "GFG_Fun()">
            click here
        </button>
          
        <p id = "GFG_DOWN" style = 
            "color: green; font-size: 24px; font-weight: bold;">
        </p>
          
        <script>
            var el_up = document.getElementById("GFG_UP");
            var el_down = document.getElementById("GFG_DOWN");
              
            el_up.innerHTML = "Click on the button to convert "
                        + "the JS datetime to MySQL datetime.";
              
            function GFG_Fun() {
                var date = new Date();
                el_down.innerHTML = "MySQL datetime - " + 
                date.toISOString().slice(0, 19).replace('T', ' ');
            }
        </script> 
    </body> 
</html>

Output:

Before clicking on the button:
After clicking on the button:

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.

<!DOCTYPE HTML> 
<html> 
    <head> 
        <title> 
            How to convert JavaScript datetime
            to MySQL datetime ?
        </title>
    </head> 
      
    <body style = "text-align:center;"> 
          
        <h1 style = "color:green;" > 
            GeeksForGeeks
        </h1>
          
        <p id = "GFG_UP" style =
            "font-size: 19px; font-weight: bold;">
        </p>
          
        <button onclick = "GFG_Fun()">
            click here
        </button>
          
        <p id = "GFG_DOWN" style = 
            "color: green; font-size: 24px; font-weight: bold;">
        </p>
          
        <script>
            var el_up = document.getElementById("GFG_UP");
            var el_down = document.getElementById("GFG_DOWN");
              
            el_up.innerHTML = "Click on the button to convert "
                        + "the JS datetime to MySQL datetime.";
              
            function GFG_Fun() {
                var date = new Date();
                el_down.innerHTML = "MySQL datetime - " + 
                        date.toISOString().split('T')[0] + ' ' 
                        + date.toTimeString().split(' ')[0];
            }
        </script> 
    </body> 
</html>

Output:

Before clicking on the button:
After clicking on the button:

My Personal Notes

Related Articles