方法:
● 使用date. toisostring()函数将date对象转换为字符串ISO格式,YYYY-MM-DDTHH:mm:ss.sssz或±YYYY-MM-DDTHH:mm:ss.sssz格式。
● 使用slice()方法提取字符串的一部分。
● 使用replace()方法将“T”字符替换为空格“”。
示例1:
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>将JavaScript datetime转换为MySQL datetime</title> </head> <body style = "text-align:center;"> <p style = "font-size: 19px; font-weight: bold;">单击按钮,将JS datetime转换为MySQL datetime</p> <button onclick = "Fun()">点击这里</button> <p id = "DOWN" style = "color: green; font-size: 24px; font-weight: bold;"> </p> <script> var el_down = document.getElementById("DOWN"); function Fun() { var date = new Date(); el_down.innerHTML = "MySQL datetime - " + date.toISOString().slice(0, 19).replace('T', ' '); } </script> </body> </html>
效果图:
示例2:
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>将JavaScript datetime转换为MySQL datetime</title> </head> <body style = "text-align:center;"> <p style = "font-size: 19px; font-weight: bold;">单击按钮,将JS datetime转换为MySQL datetime</p> <button onclick = "Fun()">点击这里</button> <p id = "DOWN" style = "color: green; font-size: 24px; font-weight: bold;"> </p> <script> var el_down = document.getElementById("DOWN"); function Fun() { var date = new Date(); el_down.innerHTML = "MySQL datetime - " + date.toISOString().split('T')[0] + ' ' + date.toTimeString().split(' ')[0]; } </script> </body> </html>
效果图:
以上就是如何将JavaScript datetime转换为MySQL datetime?的详细内容,更多请关注易知道|edz.cc其它相关文章!