这个7.60小时到8.00小时 [英] round or cast this 7.60 hour to 8.00 hour

问题描述

  SELECT  user_id，SUM（working_hrs），working_dte 
  FROM  TimeSheet 
 其中 user_leave_id    null   AND  timesheet.user_id = 106  AND  timesheet.worked_dte  BETWEEN  '  2013-11-01'  AND  '  2013-11-30' 
  GROUP   BY  working_dte，timesheet.user_id 
 
  union   all  
 
  SELECT  t.user_id，SUM（t。 working_hrs），t.worked_dte 
  FROM  TimeSheet t 
 < span class =code-keyword> join  user_leave u  on  t.user_leave_id = u.user_leave_id 
 其中 t.user_leave_id   不  null  和 u.active_rec_in<>  0  和 u.leave_status    null  和 t.user_id = 106  AND  t。 working_dte  BETWEEN  '  2013-11-01'  AND  '  2013-11-30' 
  GROUP   BY  t.worked_dte，t.user_id 

解决方案

尝试：

  SELECT  t .user_id，CEILING（SUM（t.worked_hrs）），t.worked_dte 
  FROM  TimeSheet t 
 ... 

SELECT user_id,SUM(worked_hrs),worked_dte
FROM TimeSheet
where user_leave_id is null AND  timesheet.user_id=106 AND timesheet.worked_dte BETWEEN  '2013-11-01'  AND  '2013-11-30'
GROUP BY worked_dte,timesheet.user_id

union all

SELECT t.user_id,SUM(t.worked_hrs),t.worked_dte
FROM TimeSheet t
join user_leave u on t.user_leave_id =u.user_leave_id
where t.user_leave_id is not null and u.active_rec_in <> 0  and u.leave_status is null and t.user_id=106 AND t.worked_dte BETWEEN  '2013-11-01'  AND  '2013-11-30'
GROUP BY t.worked_dte,t.user_id

解决方案

Try:

SELECT t.user_id,CEILING(SUM(t.worked_hrs)),t.worked_dte
FROM TimeSheet t
...

这篇关于这个7.60小时到8.00小时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！