Export Mysql Date Coloum in php

[[email protected]]

Hello,

 

I need to export mysql tables from php into xls

All r working fine.

But the field with the datatype 'date' is not exported properly.

In xls cell it is displayed as ########

 

What went wrong??

Thanks in advance.

 

 

[oni-kun]

Hello,

 

I need to export mysql tables from php into xls

All r working fine.

But the field with the datatype 'date' is not exported properly.

In xls cell it is displayed as ########

 

What went wrong??

Thanks in advance.

 

Excel cannot parse the date as it is in an incorrect format, most likely the encoding of the type is incorrect. Try to export in xls compatibility mode to preserve it.