Adding a value to a 'datetime' column caused an overflow.

Question

1.00/5 (2 votes)

See more:

Dear all, please give me a solution to this error.Error message is Adding a value to a 'datetime' column caused an overflow. Below is my code.

ALTER Procedure [dbo].[buson_getEMPLOYEEIDNAME_s]
(
    @Month INT,
    @Year INT
)
As
Begin
 Select EmpId,Name,(BUSON_SALARYSTR.BASICSALARY / dbo.GetNoofDaysPerMonth(@Month, @Year)) *
 (dbo.GetNoofDaysPerMonth(@Month, @Year) - dbo.NoofdaysAbsent(EmpId,@Month,@Year)) as BASICSALARY ,BUSON_SALARYSTR.CODE  FROM BUSON_EMP
 INNER JOIN BUSON_SALARYSTR ON BUSON_SALARYSTR.CODE = BUSON_EMP.SalaryStructure
End

exec buson_getEMPLOYEEIDNAME_s 2,2

Posted 5-Mar-13 9:38am

DhananjayanP

Updated 5-Mar-13 21:39pm

v3

Add a Solution

Comments

Richard C Bishop 5-Mar-13 15:40pm

You have not provided the error message.

DhananjayanP 6-Mar-13 6:00am

Adding a value to a 'datetime' column caused an overflow.

Maciej Los 5-Mar-13 16:59pm

You need to check the results returnd by GetNoofDaysPerMonth(@Month, @Year) function/stored procedure.

DhananjayanP 6-Mar-13 5:55am

result returnd by 31 days.

Maciej Los 6-Mar-13 7:15am

What you mean? Do you want to say that above procedure/function returns the count of days in selected month?

DhananjayanP 7-Mar-13 2:53am

select dbo.GetNoofDaysPerMonth(1, 2013)
i was executed it's returnd by the result
-----------
31

(1 row(s) affected)

Maciej Los 7-Mar-13 3:13am

And what values returns: NoofdaysAbsent(EmpId,@Month,@Year) function/sp?
Does it executes without errors?

DhananjayanP 7-Mar-13 3:35am

yes i executed no Error

Maciej Los 7-Mar-13 3:37am

Result, i need to know result!!!

DhananjayanP 7-Mar-13 3:42am

if i execute function no errors like this.. exec buson_getEMPLOYEEIDNAME_s 2,2013 it's returnd by
2 Ramesh 15000.000000000 2
3 Raj 12000.000000000 3
4 William 123456.000000000 4

Maciej Los 7-Mar-13 3:49am

NoofdaysAbsent(EmpId,@Month,@Year) NOT buson_getEMPLOYEEIDNAME_s!

DhananjayanP 7-Mar-13 3:51am

Thanks Maciej Los i got the point , where i done Mistake i solved this error... thank's .. then i want to convert(decimal, '12343.5787') as Basic salary .. where i want to give the convert function

Maciej Los 7-Mar-13 3:57am

Congrats!
Mark this post as "solved".

gvprabu 6-Mar-13 4:26am

Hi Check this Value for only "(BUSON_SALARYSTR.BASICSALARY / dbo.GetNoofDaysPerMonth(@Month, @Year)) *
(dbo.GetNoofDaysPerMonth(@Month, @Year) - dbo.NoofdaysAbsent(EmpId,@Month,@Year)) as BASICSALARY" with Sample Input

DhananjayanP 6-Mar-13 4:38am

Yes Same ... only

gvprabu 6-Mar-13 4:44am

I think,

Problem in your UDF.... Check some sample EmpID s

DECLARE @NoofDaysPerMonth INT, @NoofdaysAbsent INT, @EmpId INT

SELECT @EmpId=?
@NoofDaysPerMonth= dbo.GetNoofDaysPerMonth(@Month, @Year),
@NoofdaysAbsent=dbo.NoofdaysAbsent(@EmpId,@Month,@Year)

SELECT (BUSON_SALARYSTR.BASICSALARY / @NoofDaysPerMonth) * (@NoofDaysPerMonth - @NoofdaysAbsent) as BASICSALARY"
FROM BUSON_EMP
INNER JOIN BUSON_SALARYSTR ON BUSON_SALARYSTR.CODE = BUSON_EMP.SalaryStructure
WHERE EmpId =@EmpId

DhananjayanP 6-Mar-13 5:39am

it's coming Basic salary value=null

Maciej Los 6-Mar-13 8:43am

Improve question and show the code of GetNoofDaysPerMonth(@Month, @Year) function/sp. There is a problem!!!

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)