Excel值，请尝试：

  select date（'1899-12-30'）+ interval< number>天
 

例如：

 选择日期（'1899-12-30'）+间隔40000天
 

返回2009年7月6日，就像在Excel中一样。

换句话说，您可以将值作为一个整数，然后在SQL中进行转换。我实际上有点惊讶，因为Excel的0日期本质上是1900年1月0日，即1899年12月31日。我怀疑有一个问题1900年缺乏闰年.2006年2月29日，Excel的价值为60。这是有趣的，我没有意识到Excel有这个错误。

所以，上述代码适用于所有大于61的值。

I have been looking all over the web for this answer but dont understand all the things that were written. I try to do the from unix_timestamp() but it returns the wrong date. What I have done is import a xls file into the database. It converted the date to a 5 digit number. Is there a simple way? Any help would be great. This is what I have tried. I tried changing the date format in the excel file to YYYY-MM-DD and this did not work.

To go from Excel values, try this:

select date('1899-12-30') + interval <number> days

For instance:

select date('1899-12-30') + interval 40000 days

Returns July 6, 2009, just as it does in Excel.

In other words, you can bring the value in as an integer and then do the conversion in SQL.

I'm actually a little surprised because the 0 date on Excel is essentially Jan 0, 1900, which is Dec 31, 1899. I suspect there is an issue with the lack of leap year in 1900. Excel has the value of "60" represented as Feb 29,1900. This is amusing, I hadn't realized that Excel had this bug.

So, the above code works, for all values greater than 61.