ExcelToTimestamp1904.php 840 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. // Excel DateTimeStamp Result Comments
  3. return [
  4. [
  5. -1956528000,
  6. 1462,
  7. ],
  8. [
  9. -1956441600,
  10. 1463,
  11. ],
  12. [
  13. -158803200,
  14. 22269,
  15. ],
  16. [
  17. 126316800,
  18. 25569,
  19. ],
  20. [
  21. 534384000,
  22. 30292,
  23. ],
  24. [
  25. 1339545600,
  26. 39611,
  27. ],
  28. // 06:00:00
  29. [
  30. gmmktime(6, 0, 0, 1, 1, 1904), // 32-bit safe - no Y2038 problem
  31. 0.25,
  32. ],
  33. // 08:00.00
  34. [
  35. gmmktime(8, 0, 0, 1, 1, 1904), // 32-bit safe - no Y2038 problem
  36. 0.3333333333333333333,
  37. ],
  38. // 13:02:13
  39. [
  40. gmmktime(13, 02, 13, 1, 1, 1904), // 32-bit safe - no Y2038 problem
  41. 0.54321,
  42. ],
  43. // 29-Apr-2038 00:00:00 beyond PHP 32-bit Latest Date
  44. [
  45. 2156112000,
  46. 49062,
  47. ],
  48. ];