<<<<< Add Hour , Minute , Secound In Time >>>>
( If Add 15 Hour In Shift Time Then ----- Add (1/24) in Time ...
If Add 15 Minute in Shift Time Then --- Add (1/24/60) In Time ...
If Add 15 Secound In Shift Time Then --- Add (1/24/60/60) In Time.. )
------( Query Work on Oracle Developer , Option 1 is work Properly and Give Right Ans,
Option2 is Also Work But in Year is Different in Shifttime and Intime then Give Wrong Ans ,
Option 3 Is work on only Command Prompt.. )
$$$$$ OPTION 1...
select a_code,
a_shft_intime,
a_intime
from emp_attend
where A_INTIME > to_date(to_char(a_intime, 'dd/mm/rrrr ') || to_char(A_SHFT_INTIME, 'hh24:mi'), 'dd/mm/rrrr hh24:mi') + 0.010417
and get_empdeptcode(a_comp, a_code) = 'ADM'
and a_comp = 'KG'
and a_date = to_date('20/08/2011', 'dd/mm/rrrr');
$$$$$ OPTION 2
select a_code,
a_shft_intime,
a_intime
from emp_attend
where A_INTIME > A_SHFT_INTIME +0.010417
and get_empdeptcode(a_comp, a_code) = 'ADM'
and a_comp = 'KG'
and a_date = to_date('20/08/2011', 'dd/mm/rrrr');
$$$$$$ OPTION 3
select sysdate,sysdate+interval '15' minute from dual;
sysdate sysdate+interval '15
9/20/2011 5:00:19 PM 9/20/2011 5:15:19 PM
