HomeLanguagesJavascriptHow to convert JavaScript datetime to MySQL datetime ?

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:

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

2 COMMENTS

Most Popular

Dominic
32700 POSTS0 COMMENTS
Milvus
131 POSTS0 COMMENTS
Nango Kala
7076 POSTS0 COMMENTS
Nicole Veronica
12206 POSTS0 COMMENTS
Nokonwaba Nkukhwana
12299 POSTS0 COMMENTS
Shaida Kate Naidoo
7196 POSTS0 COMMENTS
Ted Musemwa
7456 POSTS0 COMMENTS
Thapelo Manthata
7169 POSTS0 COMMENTS
Umr Jansen
7158 POSTS0 COMMENTS