excelTime 用于excel 导入日期格式

用于excel 导入日期格式 格式化成 年月日形式

1. function excelTime($days, $time=false,$str='-'){
2. if(!$days)return false;
3. if(function_exists("gregoriantojd")){
4. if(is_numeric($days)){
5. //based on 1900-1-1
6. $jd = gregoriantojd(1, 1, 1970);
7. $gregorian = jdtogregorian($jd+intval($days)-25569);
8. $myDate = explode('/',$gregorian);
9. $myDateStr = str_pad($myDate[2],4,'0', STR_PAD_LEFT)
10. .$str.str_pad($myDate[0],2,'0', STR_PAD_LEFT)
11. .$str.str_pad($myDate[1],2,'0', STR_PAD_LEFT)
12. .($time?" 00:00:00":'');
13. return $myDateStr;
14. }
15. }else{
16. $date=$days>25568?$days+1:25569;
17. $ofs=(70 * 365 + 17+2) * 86400;
18. $days = date("Y".$str."m".$str."d",($date * 86400) - $ofs).($time ? " 00:00:00" : "");
19. }
20. return $days;
21. }

复制代码