blocks|key|771323|text|历史悠久的DateJS库有一个格式化例程(它覆盖了".toString()")。你也可以很容易地自己做一个，因为"Date“方法给出了你需要的所有数字。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|771324|entityMap|0|LINK|mutability|MUTABLE|url|http://www.datejs.com/^0|5|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

The venerable <a href="http://www.datejs.com/" rel="nofollow">DateJS</a> library has a formatting routine (it overrides ".toString()"). You could also do one yourself pretty easily because the "Date" methods give you all the numbers you need.

blocks|key|771362|text|虽然JS确实拥有足够的基本工具来完成这项工作，但它相当笨拙。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771363|/**
+*+You+first+need+to+create+a+formatting+function+to+pad+numbers+to+two+digits…
+**/
function+twoDigits(d)+{
++++if(0+<=+d+&&+d+<+10)+return+"0"+%2B+d.toString();
++++if(-10+<+d+&&+d+<+0)+return+"-0"+%2B+(-1*d).toString();
++++return+d.toString();
}

/**
+*+…and+then+create+the+method+to+output+the+date+string+as+desired.
+*+Some+people+hate+using+prototypes+this+way,+but+if+you+are+going
+*+to+apply+this+to+more+than+one+Date+object,+having+it+as+a+prototype
+*+makes+sense.
+**/
Date.prototype.toMysqlFormat+=+function()+{
++++return+this.getUTCFullYear()+%2B+"-"+%2B+twoDigits(1+%2B+this.getUTCMonth())+%2B+"-"+%2B+twoDigits(this.getUTCDate())+%2B+"+"+%2B+twoDigits(this.getUTCHours())+%2B+":"+%2B+twoDigits(this.getUTCMinutes())+%2B+":"+%2B+twoDigits(this.getUTCSeconds());
};|code-block|syntax|javascript|771364|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

While JS does possess enough basic tools to do this, it's pretty clunky.

<pre><code>/**
 * You first need to create a formatting function to pad numbers to two digits…
 **/
function twoDigits(d) {
 if(0 &lt;= d &amp;&amp; d &lt; 10) return "0" + d.toString();
 if(-10 &lt; d &amp;&amp; d &lt; 0) return "-0" + (-1*d).toString();
 return d.toString();
}

/**
 * …and then create the method to output the date string as desired.
 * Some people hate using prototypes this way, but if you are going
 * to apply this to more than one Date object, having it as a prototype
 * makes sense.
 **/
Date.prototype.toMysqlFormat = function() {
 return this.getUTCFullYear() + "-" + twoDigits(1 + this.getUTCMonth()) + "-" + twoDigits(this.getUTCDate()) + " " + twoDigits(this.getUTCHours()) + ":" + twoDigits(this.getUTCMinutes()) + ":" + twoDigits(this.getUTCSeconds());
};
</code></pre>

blocks|key|771401|text|var+date;
date+=+new+Date();
date+=+date.getUTCFullYear()+%2B+'-'+%2B
++++('00'+%2B+(date.getUTCMonth()%2B1)).slice(-2)+%2B+'-'+%2B
++++('00'+%2B+date.getUTCDate()).slice(-2)+%2B+'+'+%2B+
++++('00'+%2B+date.getUTCHours()).slice(-2)+%2B+':'+%2B+
++++('00'+%2B+date.getUTCMinutes()).slice(-2)+%2B+':'+%2B+
++++('00'+%2B+date.getUTCSeconds()).slice(-2);
console.log(date);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|771402|或者甚至更短：|unstyled|771403|new+Date().toISOString().slice(0,+19).replace('T',+'+');|771404|输出：|771405|2012-06-22+05:40:06|771406|对于更高级的使用情形，包括控制时区，请考虑使用http://momentjs.com/|offset|length|771407|require('moment')().format('YYYY-MM-DD+HH:mm:ss');|771408|对于momentjs的轻量级替代方案，可以考虑使用https://github.com/taylorhakes/fecha|771409|require('fecha').format('YYYY-MM-DD+HH:mm:ss')|771410|entityMap|0|LINK|mutability|MUTABLE|url|http://momentjs.com/|1|/questions/tagged/momentjs|2|https://github.com/taylorhakes/fecha^0|0|0|0|0|0|N|K|0|0|0|2|8|1|P|10|2|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|19|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1A|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|1B|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1C|8|@]|9|@]|A|$B|C]]|$1|M|3|N|5|F|7|1D|8|@]|9|@$O|1E|P|1F|1|1G]]|A|$]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$B|C]]|$1|S|3|T|5|F|7|1I|8|@]|9|@$O|1J|P|1K|1|1L]|$O|1M|P|1N|1|1O]]|A|$]]|$1|U|3|V|5|6|7|1P|8|@]|9|@]|A|$B|C]]|$1|W|3|-4|5|F|7|1Q|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]|14|$5|Z|10|11|A|$12|15]]|16|$5|Z|10|11|A|$12|17]]]]

<pre class="lang-js prettyprint-override"><code>var date;
date = new Date();
date = date.getUTCFullYear() + '-' +
 ('00' + (date.getUTCMonth()+1)).slice(-2) + '-' +
 ('00' + date.getUTCDate()).slice(-2) + ' ' + 
 ('00' + date.getUTCHours()).slice(-2) + ':' + 
 ('00' + date.getUTCMinutes()).slice(-2) + ':' + 
 ('00' + date.getUTCSeconds()).slice(-2);
console.log(date);
</code></pre>

or even shorter:

<pre class="lang-js prettyprint-override"><code>new Date().toISOString().slice(0, 19).replace('T', ' ');
</code></pre>

Output:

<pre class="lang-js prettyprint-override"><code>2012-06-22 05:40:06
</code></pre>

For more advanced use cases, including controlling the timezone, consider using <a href="http://momentjs.com/">http://momentjs.com/</a>:

<pre class="lang-js prettyprint-override"><code>require('moment')().format('YYYY-MM-DD HH:mm:ss');
</code></pre>

For a lightweight alternative to <a href="/questions/tagged/momentjs" class="post-tag" title="show questions tagged &#39;momentjs&#39;" rel="tag">momentjs</a>, consider <a href="https://github.com/taylorhakes/fecha">https://github.com/taylorhakes/fecha</a>

<pre class="lang-js prettyprint-override"><code>require('fecha').format('YYYY-MM-DD HH:mm:ss')
</code></pre>

blocks|key|771444|text|对于任意日期字符串，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771445|//+Your+default+date+object++
var+starttime+=+new+Date();
//+Get+the+iso+time+(GMT+0+==+UTC+0)
var+isotime+=+new+Date((new+Date(starttime)).toISOString()+);
//+getTime()+is+the+unix+time+value,+in+milliseconds.
//+getTimezoneOffset()+is+UTC+time+and+local+time+in+minutes.
//+60000+=+60*1000+converts+getTimezoneOffset()+from+minutes+to+milliseconds.+
var+fixedtime+=+new+Date(isotime.getTime()-(starttime.getTimezoneOffset()*60000));
//+toISOString()+is+always+24+characters+long:+YYYY-MM-DDTHH:mm:ss.sssZ.
//+.slice(0,+19)+removes+the+last+5+chars,+".sssZ",which+is+(UTC+offset).
//+.replace('T',+'+')+removes+the+pad+between+the+date+and+time.
var+formatedMysqlString+=+fixedtime.toISOString().slice(0,+19).replace('T',+'+');
console.log(+formatedMysqlString+);|code-block|syntax|javascript|771446|或者是单行解决方案，|771447|var+formatedMysqlString+=+(new+Date+((new+Date((new+Date(new+Date())).toISOString()+)).getTime()+-+((new+Date()).getTimezoneOffset()*60000))).toISOString().slice(0,+19).replace('T',+'+');
console.log(+formatedMysqlString+);|771448|当在mysql中使用时间戳时，该解决方案也适用于Node.js。|771449|@Gajus+Kuizinas's+first+answer+seems+to+modify+mozilla's+toISOString+prototype|offset|length|771450|entityMap|0|LINK|mutability|MUTABLE|url|https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toISOString^0|0|0|0|0|0|0|26|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@$O|14|P|15|1|16]]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

For arbitrary date string, 

<pre class="lang-js prettyprint-override"><code>// Your default date object 
var starttime = new Date();
// Get the iso time (GMT 0 == UTC 0)
var isotime = new Date((new Date(starttime)).toISOString() );
// getTime() is the unix time value, in milliseconds.
// getTimezoneOffset() is UTC time and local time in minutes.
// 60000 = 60*1000 converts getTimezoneOffset() from minutes to milliseconds. 
var fixedtime = new Date(isotime.getTime()-(starttime.getTimezoneOffset()*60000));
// toISOString() is always 24 characters long: YYYY-MM-DDTHH:mm:ss.sssZ.
// .slice(0, 19) removes the last 5 chars, ".sssZ",which is (UTC offset).
// .replace('T', ' ') removes the pad between the date and time.
var formatedMysqlString = fixedtime.toISOString().slice(0, 19).replace('T', ' ');
console.log( formatedMysqlString );
</code></pre>

Or a single line solution,

<pre class="lang-js prettyprint-override"><code>var formatedMysqlString = (new Date ((new Date((new Date(new Date())).toISOString() )).getTime() - ((new Date()).getTimezoneOffset()*60000))).toISOString().slice(0, 19).replace('T', ' ');
console.log( formatedMysqlString );
</code></pre>

This solution also works for Node.js when using Timestamp in mysql.

<a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toISOString" rel="noreferrer">@Gajus Kuizinas's first answer seems to modify mozilla's toISOString prototype</a>

blocks|key|771476|text|我已经给出了简单的JavaScript日期格式示例，请检查以下代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771477|var+data+=+new+Date($.now());+//+without+jquery+remove+this+$.now()
console.log(data)//+Thu+Jun+23+2016+15:48:24+GMT%2B0530+(IST)

var+d+=+new+Date,
++++dformat+=+[d.getFullYear()+,d.getMonth()%2B1,
+++++++++++++++d.getDate()
+++++++++++++++].join('-')%2B'+'%2B
++++++++++++++[d.getHours(),
+++++++++++++++d.getMinutes(),
+++++++++++++++d.getSeconds()].join(':');

console.log(dformat)+//2016-6-23+15:54:16|code-block|syntax|javascript|771478|使用momentjs|offset|length|771479|var+date+=+moment().format('YYYY-MM-DD+H:mm:ss');

console.log(date)+//+2016-06-23+15:59:08|771480|示例请查看https://jsfiddle.net/sjy3vjwm/2/|771481|entityMap|0|LINK|mutability|MUTABLE|url|http://momentjs.com/|1|https://jsfiddle.net/sjy3vjwm/2/^0|0|0|2|8|0|0|0|5|W|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@$I|11|J|12|1|13]]|A|$]]|$1|K|3|L|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|15|8|@]|9|@$I|16|J|17|1|18]]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]]]

I have given simple JavaScript date format examples please check the bellow code 

<pre><code>var data = new Date($.now()); // without jquery remove this $.now()
console.log(data)// Thu Jun 23 2016 15:48:24 GMT+0530 (IST)

var d = new Date,
 dformat = [d.getFullYear() ,d.getMonth()+1,
 d.getDate()
 ].join('-')+' '+
 [d.getHours(),
 d.getMinutes(),
 d.getSeconds()].join(':');

console.log(dformat) //2016-6-23 15:54:16
</code></pre>

Using <a href="http://momentjs.com/" rel="nofollow">momentjs</a>

<pre><code>var date = moment().format('YYYY-MM-DD H:mm:ss');

console.log(date) // 2016-06-23 15:59:08
</code></pre>

Example please check <a href="https://jsfiddle.net/sjy3vjwm/2/" rel="nofollow">https://jsfiddle.net/sjy3vjwm/2/</a>

blocks|key|986030|text|使用@Gajus+answer概念的完整解决方法(管理时区)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|986031|var+d+=+new+Date(),
++++finalDate+=+d.toISOString().split('T')[0]%2B'+'%2Bd.toTimeString().split('+')[0];
console.log(finalDate);+//2018-09-28+16:19:34+--example+output|code-block|syntax|javascript|986032|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Full workaround (to mantain the timezone) using @Gajus answer concept:

<pre><code>var d = new Date(),
 finalDate = d.toISOString().split('T')[0]+' '+d.toTimeString().split(' ')[0];
console.log(finalDate); //2018-09-28 16:19:34 --example output
</code></pre>

blocks|key|986044|text|var+_t+=+new+Date();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|986045|如果您想简单地使用UTC格式|unstyled|986046|_t.toLocaleString('indian',+{+timeZone:+'UTC'+}).replace(/(\w%2B)\/(\w%2B)\/(\w%2B),+(\w%2B)/,+'$3-$2-$1+$4');|986047|或|986048|_t.toISOString().slice(0,+19).replace('T',+'+');|986049|如果需要特定的时区，那么|986050|_t.toLocaleString('indian',+{+timeZone:+'asia/kolkata'+}).replace(/(\w%2B)\/(\w%2B)\/(\w%2B),+(\w%2B)/,+'$3-$2-$1+$4');|986051|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|T|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$B|C]]|$1|M|3|N|5|F|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|Q|3|-4|5|F|7|Z|8|@]|9|@]|A|$]]]|R|$]]

<pre><code>var _t = new Date();
</code></pre>

if you want UTC format simply

<pre><code>_t.toLocaleString('indian', { timeZone: 'UTC' }).replace(/(\w+)\/(\w+)\/(\w+), (\w+)/, '$3-$2-$1 $4');
</code></pre>

or

<pre><code>_t.toISOString().slice(0, 19).replace('T', ' ');
</code></pre>

and if want in specific timezone then 

<pre><code>_t.toLocaleString('indian', { timeZone: 'asia/kolkata' }).replace(/(\w+)\/(\w+)\/(\w+), (\w+)/, '$3-$2-$1 $4');
</code></pre>

blocks|key|986058|text|new+Date().toISOString().slice(0,+10)%2B"+"%2Bnew+Date().toLocaleTimeString('en-GB');|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|986059|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>new Date().toISOString().slice(0, 10)+&quot; &quot;+new Date().toLocaleTimeString('en-GB');
</code></pre>

blocks|key|986107|text|我用了很长时间，这对我很有帮助，你可以随意使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|986108|Date.prototype.date=function()+{
++++return+this.getFullYear()%2B'-'%2BString(this.getMonth()%2B1).padStart(2,+'0')%2B'-'%2BString(this.getDate()).padStart(2,+'0')
}

Date.prototype.time=function()+{
++++return+String(this.getHours()).padStart(2,+'0')%2B':'%2BString(this.getMinutes()).padStart(2,+'0')%2B':'%2BString(this.getSeconds()).padStart(2,+'0')
}

Date.prototype.dateTime=function()+{
++++return+this.getFullYear()%2B'-'%2BString(this.getMonth()%2B1).padStart(2,+'0')%2B'-'%2BString(this.getDate()).padStart(2,+'0')%2B'+'%2BString(this.getHours()).padStart(2,+'0')%2B':'%2BString(this.getMinutes()).padStart(2,+'0')%2B':'%2BString(this.getSeconds()).padStart(2,+'0')
}

Date.prototype.addTime=function(time)+{
++++var+time=time.split(":")
++++var+rd=new+Date(this.setHours(this.getHours()%2BparseInt(time[0])))
++++rd=new+Date(rd.setMinutes(rd.getMinutes()%2BparseInt(time[1])))
++++return+new+Date(rd.setSeconds(rd.getSeconds()%2BparseInt(time[2])))
}

Date.prototype.addDate=function(time)+{
++++var+time=time.split("-")
++++var+rd=new+Date(this.setFullYear(this.getFullYear()%2BparseInt(time[0])))
++++rd=new+Date(rd.setMonth(rd.getMonth()%2BparseInt(time[1])))
++++return+new+Date(rd.setDate(rd.getDate()%2BparseInt(time[2])))
}

Date.prototype.subDate=function(time)+{
++++var+time=time.split("-")
++++var+rd=new+Date(this.setFullYear(this.getFullYear()-parseInt(time[0])))
++++rd=new+Date(rd.setMonth(rd.getMonth()-parseInt(time[1])))
++++return+new+Date(rd.setDate(rd.getDate()-parseInt(time[2])))
}|code-block|syntax|javascript|986109|然后：|986110|new+Date().date()|986111|返回'MySQL格式‘的当前日期|986112|对于添加时间是|986113|new+Date().addTime('0:30:0')|986114|这将增加30分钟....诸若此类|986115|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

I'm using this long time and it's very helpful for me, use as you like

<pre><code>Date.prototype.date=function() {
 return this.getFullYear()+'-'+String(this.getMonth()+1).padStart(2, '0')+'-'+String(this.getDate()).padStart(2, '0')
}

Date.prototype.time=function() {
 return String(this.getHours()).padStart(2, '0')+':'+String(this.getMinutes()).padStart(2, '0')+':'+String(this.getSeconds()).padStart(2, '0')
}

Date.prototype.dateTime=function() {
 return this.getFullYear()+'-'+String(this.getMonth()+1).padStart(2, '0')+'-'+String(this.getDate()).padStart(2, '0')+' '+String(this.getHours()).padStart(2, '0')+':'+String(this.getMinutes()).padStart(2, '0')+':'+String(this.getSeconds()).padStart(2, '0')
}

Date.prototype.addTime=function(time) {
 var time=time.split(":")
 var rd=new Date(this.setHours(this.getHours()+parseInt(time[0])))
 rd=new Date(rd.setMinutes(rd.getMinutes()+parseInt(time[1])))
 return new Date(rd.setSeconds(rd.getSeconds()+parseInt(time[2])))
}

Date.prototype.addDate=function(time) {
 var time=time.split("-")
 var rd=new Date(this.setFullYear(this.getFullYear()+parseInt(time[0])))
 rd=new Date(rd.setMonth(rd.getMonth()+parseInt(time[1])))
 return new Date(rd.setDate(rd.getDate()+parseInt(time[2])))
}

Date.prototype.subDate=function(time) {
 var time=time.split("-")
 var rd=new Date(this.setFullYear(this.getFullYear()-parseInt(time[0])))
 rd=new Date(rd.setMonth(rd.getMonth()-parseInt(time[1])))
 return new Date(rd.setDate(rd.getDate()-parseInt(time[2])))
}
</code></pre>

and then just:

<pre><code>new Date().date()
</code></pre>

which returns current date in 'MySQL format'

for add time is

<pre><code>new Date().addTime('0:30:0')
</code></pre>

which will add 30 minutes.... and so on

blocks|key|771621|text|一个简单的解决方案是向MySQL发送一个时间戳并让它进行转换。Javascript使用以毫秒为单位的时间戳，而MySQL要求时间戳以秒为单位-因此需要除以1000：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771622|//+Current+date+/+time+as+a+timestamp:
let+jsTimestamp+=+Date.now();

//+**OR**+a+specific+date+/+time+as+a+timestamp:
jsTimestamp+=+new+Date("2020-11-17+16:34:59").getTime();

//+Adding+30+minutes+(to+answer+the+second+part+of+the+question):
jsTimestamp+%2B=+30+*+1000;

//+Example+query+converting+Javascript+timestamp+into+a+MySQL+date
let+sql+=+'SELECT+FROM_UNIXTIME('+%2B+jsTimestamp+%2B+'+/+1000)+AS+mysql_date_time';|code-block|syntax|javascript|771623|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

A simple solution is send a timestamp to MySQL and let it do the conversion. Javascript uses timestamps in milliseconds whereas MySQL expects them to be in seconds - so a division by 1000 is needed:
<pre><code>// Current date / time as a timestamp:
let jsTimestamp = Date.now();

// **OR** a specific date / time as a timestamp:
jsTimestamp = new Date(&quot;2020-11-17 16:34:59&quot;).getTime();

// Adding 30 minutes (to answer the second part of the question):
jsTimestamp += 30 * 1000;

// Example query converting Javascript timestamp into a MySQL date
let sql = 'SELECT FROM_UNIXTIME(' + jsTimestamp + ' / 1000) AS mysql_date_time';
</code></pre>

blocks|key|986205|text|基于其他答案构建的解决方案，同时保持时区和前导零：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|986206|var+d+=+new+Date;

var+date+=+[
++++d.getFullYear(),
++++('00'+%2B+d.getMonth()+%2B+1).slice(-2),
++++('00'+%2B+d.getDate()+%2B+1).slice(-2)
].join('-');

var+time+=+[
++++('00'+%2B+d.getHours()).slice(-2),
++++('00'+%2B+d.getMinutes()).slice(-2),
++++('00'+%2B+d.getSeconds()).slice(-2)
].join(':');

var+dateTime+=+date+%2B+'+'+%2B+time;
console.log(dateTime)+//+2021-01-41+13:06:01|code-block|syntax|javascript|986207|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Solution built on the basis of other answers, while maintaining the timezone and leading zeros:
<pre><code>var d = new Date;

var date = [
 d.getFullYear(),
 ('00' + d.getMonth() + 1).slice(-2),
 ('00' + d.getDate() + 1).slice(-2)
].join('-');

var time = [
 ('00' + d.getHours()).slice(-2),
 ('00' + d.getMinutes()).slice(-2),
 ('00' + d.getSeconds()).slice(-2)
].join(':');

var dateTime = date + ' ' + time;
console.log(dateTime) // 2021-01-41 13:06:01
</code></pre>

blocks|key|771695|text|使用toJSON()日期函数，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|771696|var+sqlDatetime+=+new+Date(new+Date().getTime()+-+new+Date().getTimezoneOffset()+*+60+*+1000).toJSON().slice(0,+19).replace('T',+'+');
console.log(sqlDatetime);|code-block|syntax|javascript|771697|​|771698|entityMap^0|2|8|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Using <code>toJSON()</code> date function as below:
<div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code>var sqlDatetime = new Date(new Date().getTime() - new Date().getTimezoneOffset() * 60 * 1000).toJSON().slice(0, 19).replace('T', ' ');
console.log(sqlDatetime);</code></pre>
</div>
</div>

blocks|key|986536|text|简单:只需替换我的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|986537|因此，只需替换T，它将如下所示："2021-02-10+18:18“SQL将吃掉它。|986538|
|986539|下面是我的函数：|986540|986541|document.getElementById("example-datetime-local-input").value；CreatedTime+=+var|986542|986543|var+newTime+=+CreatedTime.replace("T"，“")；|986544|986545|参考：https://www.tutorialrepublic.com/faq/how-to-replace-character-inside-a-string-in-javascript.php#:~:text=Answer%253A%2520Use%2520the%2520JavaScript%2520replace,the%2520global%2520(%2520g%2520)%2520modifier。|offset|length|986546|986547|https://www.tutorialrepublic.com/codelab.php?topic=faq&file=javascript-replace-character-in-a-string|986548|986549|986550|entityMap|0|LINK|mutability|MUTABLE|url|https://www.tutorialrepublic.com/faq/how-to-replace-character-inside-a-string-in-javascript.php#:~:text=Answer:%2520Use%2520the%2520JavaScript%2520replace,the%2520global%2520(%2520g%2520)%2520modifier)|1^0|0|0|0|0|0|0|0|0|0|3|54|0|0|0|0|2S|1|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|18|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|E|5|6|7|1A|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1B|8|@]|9|@]|A|$]]|$1|K|3|E|5|6|7|1C|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1D|8|@]|9|@]|A|$]]|$1|N|3|E|5|6|7|1E|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1F|8|@]|9|@$Q|1G|R|1H|1|1I]]|A|$]]|$1|S|3|E|5|6|7|1J|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1K|8|@]|9|@$Q|1L|R|1M|1|1N]]|A|$]]|$1|V|3|E|5|6|7|1O|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14]]|15|$5|10|11|12|A|$13|U]]]]

Simple: just Replace the T.
Format that I have from my &lt;input class=&quot;form-control&quot; type=&quot;datetime-local&quot; is :
&quot;2021-02-10T18:18&quot;
So just replace the T, and it would look like this: &quot;2021-02-10 18:18&quot; SQL will eat that.
Here is my function:
var CreatedTime = document.getElementById(&quot;example-datetime-local-input&quot;).value;
var newTime = CreatedTime.replace(&quot;T&quot;, &quot; &quot;);
Reference:
<a href="https://www.tutorialrepublic.com/faq/how-to-replace-character-inside-a-string-in-javascript.php#:%7E:text=Answer%3A%20Use%20the%20JavaScript%20replace,the%20global%20(%20g%20)%20modifier" rel="nofollow noreferrer">https://www.tutorialrepublic.com/faq/how-to-replace-character-inside-a-string-in-javascript.php#:~:text=Answer%3A%20Use%20the%20JavaScript%20replace,the%20global%20(%20g%20)%20modifier</a>.
<a href="https://www.tutorialrepublic.com/codelab.php?topic=faq&amp;file=javascript-replace-character-in-a-string" rel="nofollow noreferrer">https://www.tutorialrepublic.com/codelab.php?topic=faq&amp;file=javascript-replace-character-in-a-string</a>

blocks|key|986578|text|这是到目前为止我能想到的最简单的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|986579|new+Date().toISOString().slice(0,+19).replace("T",+"+")|code-block|syntax|javascript|986580|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is by far the easiest way I can think of
<pre><code>new Date().toISOString().slice(0, 19).replace(&quot;T&quot;, &quot; &quot;)
</code></pre>

blocks|key|771853|text|不同时区的Datetime|type|unstyled|depth|inlineStyleRanges|entityRanges|data|771854|它使用@Gayus解决方案，使用从toISOString()输出的格式，但它调整了分钟以适应时区。最终格式：2022-03-01+13:32:51|offset|length|style|CODE|771855|​|771856|let+ts+=+new+Date();
ts.setMinutes(ts.getMinutes()+-+ts.getTimezoneOffset());
console.log(ts.toISOString().slice(0,+19).replace('T',+'+'));|code-block|syntax|javascript|771857|771858|entityMap^0|0|H|D|1I|J|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]|$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|Y|8|@]|9|@]|A|$M|N]]|$1|O|3|I|5|6|7|Z|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|Q|$]]

<h2> Datetime in a different time zone </h2>
This uses @Gayus solution using the format outputted from <code>toISOString()</code> but it adjusts the minutes to account for the time zone.
Final format: <code>2022-03-01 13:32:51</code>
<div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code>let ts = new Date();
ts.setMinutes(ts.getMinutes() - ts.getTimezoneOffset());
console.log(ts.toISOString().slice(0, 19).replace('T', ' '));</code></pre>
</div>
</div>

Does anyone know how to convert JS dateTime to MySQL datetime? Also is there a way to add a specific number of minutes to JS datetime and then pass it to MySQL datetime?

Convert JS date time to MySQL datetime

MySQL

有人知道如何将JS datetime转换为MySQL dateTime吗？另外，有没有一种方法可以将特定的分钟数添加到JS datetime，然后将其传递给MySQL datetime？

问将JS日期时间转换为MySQL日期时间
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将JS日期时间转换为MySQL日期时间EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将JS日期时间转换为MySQL日期时间
EN