PhpSpreadsheet/tests/data/Shared/Date/ExcelToTimestamp1900.php

76 lines
1.1 KiB
PHP
Raw Permalink Normal View History

<?php
// Excel DateTimeStamp Result Comments
return [
// PHP 32-bit Earliest Date 14-Dec-1901
[
-2147472000,
714,
],
// 31-Dec-1903
[
-2082931200,
1461,
],
// Excel 1904 Calendar Base Date 01-Jan-1904
[
-2082844800,
1462,
],
// 02-Jan-1904
[
-2082758400,
1463,
],
// 19-Dec-1960
[
-285120000,
22269,
],
// PHP Base Date 01-Jan-1970
[
0,
25569,
],
// 07-Dec-1982
[
408067200,
30292,
],
// 12-Jun-2008
[
1213228800,
39611,
],
// PHP 32-bit Latest Date 9-Jan-2038
[
2147472000,
50424,
],
// 18-May-1903 13:37:46
[
-2102494934,
1234.56789,
],
// 18-Oct-1933 16:17:37
[
-1142494943,
12345.6789,
],
// 12:00:00
[
43200,
0.5,
],
// 18:00.00
[
64800,
0.75,
],
// 02:57:46
[
10666,
0.12345,
],
];