ExcelToTimestamp1900.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. <?php
  2. // Excel DateTimeStamp Result Comments
  3. return [
  4. // PHP 32-bit Earliest Date 14-Dec-1901
  5. [
  6. -2147472000,
  7. 714,
  8. ],
  9. // 31-Dec-1903
  10. [
  11. -2082931200,
  12. 1461,
  13. ],
  14. // Excel 1904 Calendar Base Date 01-Jan-1904
  15. [
  16. -2082844800,
  17. 1462,
  18. ],
  19. // 02-Jan-1904
  20. [
  21. -2082758400,
  22. 1463,
  23. ],
  24. // 19-Dec-1960
  25. [
  26. -285120000,
  27. 22269,
  28. ],
  29. // PHP Base Date 01-Jan-1970
  30. [
  31. 0,
  32. 25569,
  33. ],
  34. // 07-Dec-1982
  35. [
  36. 408067200,
  37. 30292,
  38. ],
  39. // 12-Jun-2008
  40. [
  41. 1213228800,
  42. 39611,
  43. ],
  44. // PHP 32-bit Latest Date 9-Jan-2038
  45. [
  46. 2147472000,
  47. 50424,
  48. ],
  49. // 18-May-1903 13:37:46
  50. [
  51. -2102494934,
  52. 1234.56789,
  53. ],
  54. // 18-Oct-1933 16:17:37
  55. [
  56. -1142494943,
  57. 12345.6789,
  58. ],
  59. // 12:00:00
  60. [
  61. 43200,
  62. 0.5,
  63. ],
  64. // 18:00.00
  65. [
  66. 64800,
  67. 0.75,
  68. ],
  69. // 02:57:46
  70. [
  71. 10666,
  72. 0.12345,
  73. ],
  74. // 29-Apr-2038 00:00:00 beyond PHP 32-bit Latest Date
  75. [
  76. 2156112000,
  77. 50524,
  78. ],
  79. [-2147483648, -2147483648 / 86400], // Okay on 64- and 32-bit systems
  80. [-2147483649, -2147483649 / 86400], // Skipped test on 32-bit
  81. ];