首先创建一个表 里面有两个dateTime类型的字段 如:beginTime,endTime ,表名:zangyou 。
用mysql自带的timediff函数转化为Float类型,会去掉分钟数,不准确,下面这段sql文能精确到0.0000
SQL:
select
DATE_FORMAT(z.beginTime,'%Y-%m-%d %H:%i') as beginTime ,
DATE_FORMAT(z.endTime,'%Y-%m-%d %H:%i') as endTime,
timediff(endTime , beginTime) as timeDiffe,
timediff(endTime , beginTime) +
i f( (extract(minute from endTime) - extract(minute from beginTime))<0,1,0) +
(extract(minute from endTime) - extract(minute from beginTime)
)/60 as hoursDiff
from zangyou z