DATEDIF.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112
  1. <?php
  2. return [
  3. [365, '"2016-01-01", "2016-12-31", "YD"'],
  4. [364, '"2015-01-01", "2015-12-31", "YD"'],
  5. [364, '"2015-01-01", "2016-12-31", "YD"'],
  6. [365, '"2016-01-01", "2017-12-31", "YD"'],
  7. [364, '"2017-01-01", "2018-12-31", "YD"'],
  8. ['#VALUE!', '"ABC", "2007-1-10", "Y"'],
  9. ['#VALUE!', '"2007-1-1", "DEF", "Y"'],
  10. ['#VALUE!', '"2007-1-1", "2007-1-10", "XYZ"'],
  11. ['#NUM!', '"2007-1-10", "2007-1-1", "Y"'],
  12. [0, '"2007-12-31", "2008-1-10", "Y"'],
  13. [0, '"2007-1-1", "2007-1-10", "Y"'],
  14. [0, '"2007-1-1", "2007-1-10", "M"'],
  15. [9, '"2007-1-1", "2007-1-10", "D"'],
  16. [0, '"2007-1-1", "2007-1-10", "YM"'],
  17. [9, '"2007-1-1", "2007-1-10", "YD"'],
  18. [9, '"2007-1-1", "2007-1-10", "MD"'],
  19. [0, '"2007-1-1", "2007-12-31", "Y"'],
  20. [11, '"2007-1-1", "2007-12-31", "M"'],
  21. [364, '"2007-1-1", "2007-12-31", "D"'],
  22. [11, '"2007-1-1", "2007-12-31", "YM"'],
  23. [364, '"2007-1-1", "2007-12-31", "YD"'],
  24. [30, '"2007-1-1", "2007-12-31", "MD"'],
  25. [1, '"2007-1-1", "2008-7-1", "Y"'],
  26. [18, '"2007-1-1", "2008-7-1", "M"'],
  27. [547, '"2007-1-1", "2008-7-1", "D"'],
  28. [6, '"2007-1-1", "2008-7-1", "YM"'],
  29. [181, '"2007-1-1", "2008-7-1", "YD"'],
  30. [0, '"2007-1-1", "2008-7-1", "MD"'],
  31. [0, '"2007-1-1", "2007-1-31", "Y"'],
  32. [0, '"2007-1-1", "2007-1-31", "M"'],
  33. [30, '"2007-1-1", "2007-1-31", "D"'],
  34. [0, '"2007-1-1", "2007-1-31", "YM"'],
  35. [30, '"2007-1-1", "2007-1-31", "YD"'],
  36. [30, '"2007-1-1", "2007-1-31", "MD"'],
  37. [0, '"2007-1-1", "2007-2-1", "Y"'],
  38. [1, '"2007-1-1", "2007-2-1", "M"'],
  39. [31, '"2007-1-1", "2007-2-1", "D"'],
  40. [1, '"2007-1-1", "2007-2-1", "YM"'],
  41. [31, '"2007-1-1", "2007-2-1", "YD"'],
  42. [0, '"2007-1-1", "2007-2-1", "MD"'],
  43. [0, '"2007-1-1", "2007-2-28", "Y"'],
  44. [1, '"2007-1-1", "2007-2-28", "M"'],
  45. [58, '"2007-1-1", "2007-2-28", "D"'],
  46. [1, '"2007-1-1", "2007-2-28", "YM"'],
  47. [58, '"2007-1-1", "2007-2-28", "YD"'],
  48. [27, '"2007-1-1", "2007-2-28", "MD"'],
  49. [0, '"2007-1-31", "2007-2-1", "Y"'],
  50. [0, '"2007-1-31", "2007-2-1", "M"'],
  51. [1, '"2007-1-31", "2007-2-1", "D"'],
  52. [0, '"2007-1-31", "2007-2-1", "YM"'],
  53. [1, '"2007-1-31", "2007-2-1", "YD"'],
  54. [1, '"2007-1-31", "2007-2-1", "MD"'],
  55. [0, '"2007-1-31", "2007-3-1", "Y"'],
  56. [1, '"2007-1-31", "2007-3-1", "M"'],
  57. [29, '"2007-1-31", "2007-3-1", "D"'],
  58. [1, '"2007-1-31", "2007-3-1", "YM"'],
  59. [29, '"2007-1-31", "2007-3-1", "YD"'],
  60. [-2, '"2007-1-31", "2007-3-1", "MD"'],
  61. [0, '"2007-1-31", "2007-3-31", "Y"'],
  62. [2, '"2007-1-31", "2007-3-31", "M"'],
  63. [59, '"2007-1-31", "2007-3-31", "D"'],
  64. [2, '"2007-1-31", "2007-3-31", "YM"'],
  65. [59, '"2007-1-31", "2007-3-31", "YD"'],
  66. [0, '"2007-1-31", "2007-3-31", "MD"'],
  67. [0, '"2008-1-1", "2008-9-1", "Y"'],
  68. [8, '"2008-1-1", "2008-9-1", "M"'],
  69. [244, '"2008-1-1", "2008-9-1", "D"'],
  70. [8, '"2008-1-1", "2008-9-1", "YM"'],
  71. [244, '"2008-1-1", "2008-9-1", "YD"'],
  72. [0, '"2008-1-1", "2008-9-1", "MD"'],
  73. [1, '"2007-2-1", "2008-4-1", "Y"'],
  74. [14, '"2007-2-1", "2008-4-1", "M"'],
  75. [425, '"2007-2-1", "2008-4-1", "D"'],
  76. [2, '"2007-2-1", "2008-4-1", "YM"'],
  77. [59, '"2007-2-1", "2008-4-1", "YD"'],
  78. [0, '"2007-2-1", "2008-4-1", "MD"'],
  79. [47, '"1960-12-19", "2008-6-28", "Y"'],
  80. [570, '"1960-12-19", "2008-6-28", "M"'],
  81. [17358, '"1960-12-19", "2008-6-28", "D"'],
  82. [6, '"1960-12-19", "2008-6-28", "YM"'],
  83. [191, '"1960-12-19", "2008-6-28", "YD"'],
  84. [9, '"1960-12-19", "2008-6-28", "MD"'],
  85. [25, '"1982-12-7", "2008-6-28", "Y"'],
  86. [306, '"1982-12-7", "2008-6-28", "M"'],
  87. [9335, '"1982-12-7", "2008-6-28", "D"'],
  88. [6, '"1982-12-7", "2008-6-28", "YM"'],
  89. [203, '"1982-12-7", "2008-6-28", "YD"'],
  90. [21, '"1982-12-7", "2008-6-28", "MD"'],
  91. [2, '"2007-12-25", "2010-3-17", "Y"'],
  92. [26, '"2007-12-25", "2010-3-17", "M"'],
  93. [813, '"2007-12-25", "2010-3-17", "D"'],
  94. [2, '"2007-12-25", "2010-3-17", "YM"'],
  95. [82, '"2007-12-25", "2010-3-17", "YD"'],
  96. [20, '"2007-12-25", "2010-3-17", "MD"'],
  97. [51, '"19-12-1960", "26-01-2012", "Y"'],
  98. [613, '"19-12-1960", "26-01-2012", "M"'],
  99. [18665, '"19-12-1960", "26-01-2012", "D"'],
  100. [1, '"19-12-1960", "26-01-2012", "YM"'],
  101. [11, '"19-12-1960", "26-11-1962", "YM"'],
  102. [38, '"19-12-1960", "26-01-2012", "YD"'],
  103. [7, '"19-12-1960", "26-01-2012", "MD"'],
  104. [0, '"19-12-1960", "12-12-1961", "Y"'],
  105. [1, '"19-12-1960", "12-12-1962", "Y"'],
  106. [51, '"19-12-1960", "12-12-2012", "Y"'],
  107. [0, '"1982-12-07", "1982-12-7", "D"'],
  108. [244, '"2008-1-1", "2008-9-1"'], // default unit is D
  109. ['exception', '"2008-1-1"'],
  110. ['exception', ''],
  111. ];