By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,908 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

ERROR: arithmetic overflow error converting expression to data type smalldatetime

P: 1
this error occure while I am executing my query like:

Expand|Select|Wrap|Line Numbers
  1. select EMPNAME,A.EMPCODE,B.MACHINEID,EMPTYPE,PUNCHTIME,punchdate,sum(Amount)'Total Amount'  
  2. from B,A,C 
  3. where A.EMPCODE=C.empcode 
  4. and  C.machineid=B.machineid 
  5. and ( punchdate >=28/08/2012 and punchdate<=30/08/2012  )
  6. and ( punchtime>=08:00 and punchtime<=18:00 )
  7. and A.EMPCODE LIKE  '%'  
  8. group by EMPNAME,A.EMPCODE,B.MACHINEID,EMPTYPE,PUNCHTIME,PUNCHDATE
Apr 23 '14 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,347
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.
Apr 23 '14 #2

P: 1
This is related to the column in your database with smalldatetime.
so convert that when displaying the results.
Oct 10 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.