我想在我的报告日期+时间，但我不知道如何替换time_format，以获得日期也在那里。 time_format(T1.日期，“%d/%m/%y-%h:%i:%s”）

create VIEW `test`  AS 
with cte as (select `entries`.`emp_id` AS `emp_id`,`entries`.`Date` AS `Date`,
row_number() over ( partition by `entries`.`emp_id` order by `entries`.`Date`) - 1 AS `rn` 
from `entries`)select `user`.`Name` AS `name`,
time_format( `t1`.`Date`,'%H:%i:%s') AS `IN`,time_format(`t2`.`Date`,'%H:%i:%s') AS `OUT`,
timediff(`t2`.`Date`,`t1`.`Date`) AS `Work Time` from ((`user` join `cte` `t1` on(`user`.`emp_id` = `t1`.`emp_id`)) 
left join (select `entries`.`emp_id` AS `emp_id`,`entries`.`Date` AS `Date`,
row_number() 
over ( partition by `entries`.`emp_id` order by `entries`.`Date`) - 1 AS `rn` from `entries`) `t2` 
on(`t1`.`emp_id` = `t2`.`emp_id` and `t1`.`rn` DIV 2 = `t2`.`rn` DIV 2 and `t2`.`rn` MOD 2)) 
where !(`t1`.`rn` MOD 2) order by date_format(`t1`.`Date`,'%d/%M/%Y') ;