模拟SQLSERVER的两个函数：dateadd(),datediff()

时间： 2021-07-31 作者：daque

<?php//文献名：date.inc.php3//在运用这两个因变量前，要先将日子或日子功夫变换成timestamp典型。//如：//$today=mktime(0,0,0,date("m"),date("d"),date("y"));/****模仿sqlserver中的dateadd因变量*******$part 典型：string取值范畴：year,month,day,hour,min,sec表白：要减少的日子的哪个局部$n 典型：数值表白：要减少几何，按照$part确定减少哪个局部可为负数$datetime典型：timestamp表白：减少的基数归来典型：timestamp**************中断**************/function dateadd($part,$n,$datetime){$year=date("y",$datetime);$month=date("m",$datetime);$day=date("d",$datetime);$hour=date("h",$datetime);$min=date("i",$datetime);$sec=date("s",$datetime);$part=strtolower($part);$ret=0;switch ($part) {case "year":$year+=$n;break;case "month":$month+=$n;break;case "day":$day+=$n;break;case "hour":$hour+=$n;break;case "min":$min+=$n;break;case "sec":$sec+=$n;break;default:return $ret;break;}$ret=mktime($hour,$min,$sec,$month,$day,$year);return $ret;}/****模仿sqlserver中的datediff因变量*******$part 典型：string取值范畴：year,month,day,hour,min,sec表白：要减少的日子的哪个局部$date1,$date2 典型：timestamp表白：要比拟的两个日子归来典型：数值**************中断*(*************/function datediff($part,$date1,$date2){//$diff=$date2-$date1;$year1=date("y",$date1);$year2=date("y",$date2);$month2=date("m",$date2);$month1=date("m",$date1);$day2=date("d",$date2);$day1=date("d",$date1);$hour2=date("d",$date2);$hour1=date("d",$date1);$min2=date("i",$date2);$min1=date("i",$date1);$sec2=date("s",$date2);$sec1=date("s",$date1);$part=strtolower($part);$ret=0;switch ($part) {case "year":$ret=$year2-$year1;break;case "month":$ret=($year2-$year1)*12+$month2-$month1;break;case "day":$ret=(mktime(0,0,0,$month2,$day2,$year2)-mktime(0,0,0,$month1,$day1,$year1))/(3600*24);break;case "hour":$ret=(mktime($hour2,0,0,$month2,$day2,$year2)-mktime($hour1,0,0,$month1,$day1,$year1))/3600;break;case "min":$ret=(mktime($hour2,$min2,0,$month2,$day2,$year2)-mktime($hour1,$min1,0,$month1,$day1,$year1))/60;break;case "sec":$ret=$date2-$date1;break;default:return $ret;break;}return $ret;}?>

模拟SQLSERVER的两个函数：dateadd(),datediff()

相关推荐

推荐下载

热门阅览

最新排行