Please help me to find simple mathod to get working hours .The following is my script
ardate is date argument in afunction
id would be integer argument
Choose case dayname(ardate)
case 'monday'
select mon_hrs
into:l_db_hrs from workhrs
where empid= :id;
case 'tuesday'
select tue_hrs
into:l_db_hrs from workhrs
where empid= = :id;
case 'wednesday'
select wed_hrs
into:l_db_hrs from workhrs
where empid= = :id;
End Choose
With Many Thanks
polachan
Go to the complete details ...