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
I need to round it off 28.75 = 29
32.25 = 32
I have to use floor and ceil. How can I use both?