ExcelToTimestamp1900Timezone.php 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
  1. <?php
  2. // Excel DateTimeStamp Timezone Result Comments
  3. return [
  4. // 19-Dec-1960 00:00:00 EST => 19-Dec-1960 05:00:00 UTC
  5. [
  6. -285102000,
  7. 22269,
  8. 'America/New_York',
  9. ],
  10. // 01-Jan-1970 00:00:00 EST => 01-Jan-1970 05:00:00 UTC PHP Base Date
  11. [
  12. 18000,
  13. 25569,
  14. 'America/New_York',
  15. ],
  16. // 07-Dec-1982 00:00:00 EST => 07-Dec-1982 05:00:00 UTC
  17. [
  18. 408085200,
  19. 30292,
  20. 'America/New_York',
  21. ],
  22. // 12-Jun-2008 00:00:00 EDT => 12-Jun-2008 04:00:00 UTC
  23. [
  24. 1213243200,
  25. 39611,
  26. 'America/New_York',
  27. ],
  28. // 19-Jan-2038 00:00:00 EST => 19-Jan-2038 05:00:00 UTC PHP 32-bit Latest Date
  29. [
  30. 2147490000,
  31. 50424,
  32. 'America/New_York',
  33. ],
  34. // 05-Mar-1961 13:37:46 EST => 05-Mar-1961 18:37:46 UTC
  35. [
  36. -278486534,
  37. 22345.56789,
  38. 'America/New_York',
  39. ],
  40. // 05-Mar-1961 16:17:37 EST => 05-Mar-1961 21:17:37 UTC
  41. [
  42. -278476943,
  43. 22345.6789,
  44. 'America/New_York',
  45. ],
  46. // 12:00:00 EST => 17:00:00 UTC
  47. [
  48. 61200,
  49. 0.5,
  50. 'America/New_York',
  51. ],
  52. // 18:00.00 EST => 23:00:00 UTC
  53. [
  54. 82800,
  55. 0.75,
  56. 'America/New_York',
  57. ],
  58. // 02:57:46 EST => 07:57:46 UTC
  59. [
  60. 28666,
  61. 0.12345,
  62. 'America/New_York',
  63. ],
  64. // 02-Nov-2012 00:00:00 EDT => 02-Nov-2012 04:00:00 UTC
  65. [
  66. 1351828800,
  67. 41215,
  68. 'America/New_York',
  69. ],
  70. // 19-Dec-1960 00:00:00 NZST => 18-Dec-1960 12:00:00 UTC
  71. [
  72. -285163200,
  73. 22269,
  74. 'Pacific/Auckland',
  75. ],
  76. // 01-Jan-1970 00:00:00 NZST => 31-Dec-1969 12:00:00 UTC PHP Base Date
  77. [
  78. -43200,
  79. 25569,
  80. 'Pacific/Auckland',
  81. ],
  82. // 07-Dec-1982 00:00:00 NZDT => 06-Dec-1982 11:00:00 UTC
  83. [
  84. 408020400,
  85. 30292,
  86. 'Pacific/Auckland',
  87. ],
  88. // 12-Jun-2008 00:00:00 NZST => 11-Jun-2008 12:00:00 UTC
  89. [
  90. 1213185600,
  91. 39611,
  92. 'Pacific/Auckland',
  93. ],
  94. // 18-Jan-2038 12:00:00 NZDT => 17-Jan-2038 23:00:00 UTC PHP 32-bit Latest Date
  95. [
  96. 2147382000,
  97. 50423.5,
  98. 'Pacific/Auckland',
  99. ],
  100. // 05-Mar-1961 13:37:46 NZST => 05-Mar-1961 01:37:46 UTC
  101. [
  102. -278547734,
  103. 22345.56789,
  104. 'Pacific/Auckland',
  105. ],
  106. // 05-Mar-1961 16:17:37 NZST => 05-Mar-1961 04:17:37 UTC
  107. [
  108. -278538143,
  109. 22345.6789,
  110. 'Pacific/Auckland',
  111. ],
  112. // 12:00:00 NZST => 00:00:00 UTC
  113. [
  114. 0,
  115. 0.5,
  116. 'Pacific/Auckland',
  117. ],
  118. // 18:00.00 NZST => 06:00:00 UTC
  119. [
  120. 21600,
  121. 0.75,
  122. 'Pacific/Auckland',
  123. ],
  124. // 02:57:46 NZST => 14:57:46 UTC
  125. [
  126. -32534,
  127. 0.12345,
  128. 'Pacific/Auckland',
  129. ],
  130. // 02-Nov-2012 00:00:00 NZDT => 01-Nov-2012 11:00:00 UTC
  131. [
  132. 1351767600,
  133. 41215,
  134. 'Pacific/Auckland',
  135. ],
  136. ];