How to convert JavaScript datetime to MySQL datetime ?

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.

filter_none

edit
close

play_arrow

link
brightness_4
code

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

chevron_right


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.

filter_none

edit
close

play_arrow

link
brightness_4
code

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

chevron_right


Output:

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


My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.