excelTime 用于excel 导入日期格式
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
发布: 2016-07-25 08:48:43
用于excel 导入日期格式 格式化成 年月日形式
- function excelTime($days, $time=false,$str='-'){
- if(!$days)return false;
- if(function_exists("gregoriantojd")){
- 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.str_pad($myDate[0],2,'0', STR_PAD_LEFT)
- .$str.str_pad($myDate[1],2,'0', STR_PAD_LEFT)
- .($time?" 00:00:00":'');
- return $myDateStr;
- }
- }else{
- $date=$days>25568?$days+1:25569;
- $ofs=(70 * 365 + 17+2) * 86400;
- $days = date("Y".$str."m".$str."d",($date * 86400) - $ofs).($time ? " 00:00:00" : "");
- }
- return $days;
- }
复制代码
|
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
作者最新文章
-
2025-02-26 03:58:14
-
2025-02-26 03:38:10
-
2025-02-26 03:17:10
-
2025-02-26 02:49:09
-
2025-02-26 01:08:13
-
2025-02-26 00:46:10
-
2025-02-25 23:42:08
-
2025-02-25 22:50:13
-
2025-02-25 21:54:11
-
2025-02-25 20:45:11