1292 - Truncated incorrect time value :'08:00:00pm'

[vinodh ramadurai]

The below is the code :

i am getting the error at line

''

begin
declare v_punchintime char(20);
declare v_punchouttime char(15);
declare v_break char(20);

declare v_totworkinghours char(20);




select Tin into v_punchintime from hr_transattendancemanualpunch where empid = p_empid and date = p_date;




select Tout into v_punchouttime from hr_transattendancemanualpunch where empid = p_empid and date = p_date;



I am getting the error in 'if v_break is not null then'. please provide the solution.

select stime2 into v_break from hr_transcanteenmanualpunch where empid = p_empid and CmpDate = p_date;
if v_break is not null then


select 'e';

set v_totworkinghours = subtime(v_punchouttime , v_punchintime) ;

set v_totworkinghours = subtime(v_totworkinghours,'01:00:00' );
select 'f';
else
select 'g';
set v_totworkinghours = subtime(v_punchouttime , v_punchintime);
select 'h';
end if;

set p_workinghours = v_totworkinghours;
select v_punchintime,v_punchouttime,v_break, p_workinghours ;
end


thanks,
vinodh