DATETIME DATA TYPE RESULTED IN AN OUT-OF-RANGE VALUE

[rhicky]

Friends,
in the SQL query below, I can run normally on the SQL Server Query. However, when using within a system developed by me, it gives the following message: "The Conversion of a VARCHAR DATA TYPE TO A DATEETIME DATA TYPE RESULTED IN AN OUT-OF-RANGE VALUE."
I have tried to use Convert and Cast, but even then it gives this error. How to solve?

Select all

select x.CODPESSOA 
from vatestado x 
where x.codcoligada = 1 
group by x.codpessoa 
having sum(datediff(day, DTINICIO, DTFINAL)) >= 2

[Renato Menezes Viana]

Rhicky: Can you improve the bug clues?

I believe the problem is in DateDiff, do not you think?

Select all

datediff(day, DTINICIO, DTFINAL)

later, repairing better I realized that you talk about SQL Server ... Do you realize that this forum is Oracle?

Sorry, I can not help more about SQL Server.

ABS,

Renato Viana

[stcoutinho]

Renato,

I do not know the SQL Server, but who knows this link helps you:
http://www.toadworld.com/platforms/sql- ... value.aspx http://dba.stackexchange.com/questions/ ... ange-value Hugs,

Sergio

[Renato Menezes Viana]

Coutinho: I am an adept of "every monkey on your branch" and so I did not comment anything for Rhicky.

Thank you for your attention and saw in the link below most tips with dates in SQL Server:

ABS