bigint类型时间转date类型:
DATE_FORMAT(FROM_UNIXTIME(start_time/1000),’%Y-%m-%d %H:%i:%S’) as start_time,
DATE_FORMAT(FROM_UNIXTIME(end_time/1000),’%Y-%m-%d %H:%i:%S’) as end_time,
bigint类型时间运算精确到毫秒(单位/分):
convert(IFNULL(TIMESTAMPDIFF(SECOND,DATE_FORMAT(FROM_UNIXTIME(start_time/1000),’%Y-%m-%d %H:%i:%S’),
DATE_FORMAT(FROM_UNIXTIME(end_time/1000),’%Y-%m-%d %H:%i:%S’))/60,0),decimal(12,2)) ,
结束时间减去开始时间运算:
convert(IFNULL(TIMESTAMPDIFF(SECOND,DATE_FORMAT(FROM_UNIXTIME(b.start_time/1000),’%Y-%m-%d %H:%i:%S’)
,DATE_FORMAT(FROM_UNIXTIME(b.end_time/1000),’%Y-%m-%d %H:%i:%S’))/60,0),decimal(12,2)) convert_time
mysql bigint类型时间做运算
最新推荐文章于 2023-01-01 10:47:17 发布