1、mysql
CREATE DEFINER=`dtssyncwriter`@`%` FUNCTION `TIMER_MIN`(
startDay datetime,endDay datetime) RETURNS varchar(255) CHARSET utf8
SQL SECURITY INVOKER
BEGIN
DECLARE str VARCHAR(255);
IF (DATE_FORMAT(endDay,'%H%i%s') >= DATE_FORMAT(startDay,'%H%i%s') && DATE_FORMAT(endDay,'%Y%m%d') >= DATE_FORMAT(startDay,'%Y%m%d'))
THEN SET str = CONCAT(
CASE WHEN DATEDIFF(endDay, startDay) != 0
THEN CONCAT(DATEDIFF(endDay, startDay),'天 ') ELSE '' END,
TIME_FORMAT(
TIMEDIFF(
DATE_ADD(
endDay,
INTERVAL - DATEDIFF(endDay, startDay) DAY
),
startDay
),
'%H:%i'
)
);
ELS