ERROR: arithmetic overflow error converting expression to data type smalldatetime

[bhagyada123]

this error occure while I am executing my query like:

select EMPNAME,A.EMPCODE,B.MACHINEID,EMPTYPE,PUNCHTIME,punchdate,sum(Amount)'Total Amount'  
from B,A,C 
where A.EMPCODE=C.empcode 
and  C.machineid=B.machineid 
and ( punchdate >=28/08/2012 and punchdate<=30/08/2012  )
and ( punchtime>=08:00 and punchtime<=18:00 )
and A.EMPCODE LIKE  '%'  
group by EMPNAME,A.EMPCODE,B.MACHINEID,EMPTYPE,PUNCHTIME,PUNCHDATE

[Rabbit]

This is not VB.Net code. This is SQL code. Let us know what DBMS you're using and we will move it to the correct forum.

Please use code tags when posting code or formatted data.

[Priyakara]

This is related to the column in your database with smalldatetime.
so convert that when displaying the results.