将mySQL日期转换为Javascript日期 [英] Convert a mySQL date to Javascript date

问题描述

mySQL日期格式为'YYYY-MM-DD'（ISO格式）。

解决方案

鉴于您的澄清，您不能更改传入日期的格式，您需要这样：

  var dateParts = isoFormatDateString.split（ - ）; 
 var jsDate = new Date（dateParts [0]，dateParts [1]  -  1，dateParts [2] .substr（0,2））; 
  

原始回复：

有没有你不能得到时间戳而不是日期字符串的原因？这将通过以下方式完成：

  SELECT UNIX_TIMESTAMP（date）AS epoch_time FROM table; 
  

然后将epoch_time转换为JavaScript，这是一个简单的事情：

  var myDate = new Date（epoch_time * 1000）; 
  

乘以1000是因为JavaScript需要毫秒数，UNIX_TIMESTAMP给出秒数。

What would be the best way to convert a mysql date format date into a javascript Date object?

mySQL date format is 'YYYY-MM-DD' (ISO Format).

解决方案

Given your clarification that you cannot change the format of the incoming date, you need something like this:

var dateParts = isoFormatDateString.split("-");
var jsDate = new Date(dateParts[0], dateParts[1] - 1, dateParts[2].substr(0,2));

Original response:

Is there a reason you can't get a timestamp instead of the date string? This would be done by something like:

 SELECT UNIX_TIMESTAMP(date) AS epoch_time FROM table;

Then get the epoch_time into JavaScript, and it's a simple matter of:

var myDate = new Date(epoch_time * 1000);

The multiplying by 1000 is because JavaScript takes milliseconds, and UNIX_TIMESTAMP gives seconds.

这篇关于将mySQL日期转换为Javascript日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！