/**
* [excelTime description]
* @Author:XuXianGang
* @Method:excel 转换时间
* @DateTime:2022-06-06T09:36:37+0800
* @param [type] $days [description]
* @param boolean $time [description]
* @return [type] [description]
*/
function excelTime($days, $time=false){
if(is_numeric($days)){
//based on 1900-1-1
$jd = GregorianToJD(1, 1, 1970);
$gregorian = JDToGregorian($jd+intval($days)-25569);
$myDate = explode('/',$gregorian);
$myDateStr = str_pad($myDate[2],4,'0', STR_PAD_LEFT)
."-".str_pad($myDate[0],2,'0', STR_PAD_LEFT)
."-".str_pad($myDate[1],2,'0', STR_PAD_LEFT)
.($time?" 00:00:00":'');
return $myDateStr;
}
return $days;
}
// 调用方式
$t = "44972";
$this->excelTime($t);
php 导入excel 表格里时间 进行处理
最新推荐文章于 2024-08-22 09:44:18 发布