php Programming Glossary: datevalue
Date from excel changes when uploaded into mysql http://stackoverflow.com/questions/9298429/date-from-excel-changes-when-uploaded-into-mysql Assuming the Windows 1900 calendar function ExcelToPHP dateValue 0 myExcelBaseDate 25569 Adjust for the spurious 29 Feb 1900.. 25569 Adjust for the spurious 29 Feb 1900 Day 60 if dateValue 60 myExcelBaseDate Perform conversion if dateValue 1 utcDays.. 60 if dateValue 60 myExcelBaseDate Perform conversion if dateValue 1 utcDays dateValue myExcelBaseDate returnValue round utcDays..
|
