From cc243c14b6c7f5ada0bf7b837aa58070530e7fbd Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 27 Mar 2017 11:17:14 +0800 Subject: [PATCH] SimpleExcel.php --- SimpleExcel.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/SimpleExcel.php b/SimpleExcel.php index 18bce6fe..bea9c93a 100644 --- a/SimpleExcel.php +++ b/SimpleExcel.php @@ -386,8 +386,11 @@ class Pman_Core_SimpleExcel extends Pman $dataFormat = 'date'; $format = empty($format) ? $this->formats['_default_date_format_']: $format; $ut_to_ed_diff = 86400 * 25569; + $gmt = strtotime('1970-01-01'); - $v = (strtotime($v) + $ut_to_ed_diff) / 86400; + $v = (strtotime($v) + $ut_to_ed_diff - $gmt) / 86400; + // need to +8hrs to get real time.. + } -- 2.39.2