Link to home
Start Free TrialLog in
Avatar of anumoses
anumosesFlag for United States of America

asked on

oracle query

select ds.payroll_id as payroll_id,
       sum(ds.total_hours)/100 as sum_wk_hours
  from dept_staff ds, not_avail_reason nar
 where ds.schedule_date between  '27-may-2012' and '02-jun-2012'
   and ds.reason_code = nar.reason_code
   and nar.pay_hours_flag = 'Y'
   and payroll_id in ('ZZW0024403','ZZW0023632')
  group by payroll_id

PAYROLL_ID|SUM_WK_HOURS
ZZW0023632|28.75
ZZW0024403|32.25

I need to round it off 28.75 = 29
32.25 = 32

I have to use floor and ceil. How can I use both?
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anumoses

ASKER

thanks. Thought so.