Difference of two datetime columns caused overflow at runtime 
Author Message
 Difference of two datetime columns caused overflow at runtime

Hi,

The Crystal Report uses an SP where date diff function is used.
In the Sp it is used in the following fashion:

 AND ( (convert(float,DATEDIFF(second, Birth_Date, Date_Spec_Collected)) <
86400)

in the WHERE clause.

When a verify database is done on the report, it gives the error:
"
Difference of two datetime columns caused overflow at runtime

"
Thanks for any help.

Regards
Brijesh



Wed, 25 May 2005 05:49:58 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Compiler Differences Cause Runtime Error - Need Help

2. How to calculate the difference between two dates (time elapsed between two program starts)

3. combine two columns from two tables?

4. Multiline Textbox Cause Page Overflows when Printing or doesn't print all lines

5. Why does this cause an overflow?

6. User Control causes stack overflow

7. Mouse events causing overflow error?

8. User Control causes stack overflow

9. PEGetWindowHandle Cause a Overflow error ?

10. Cause of error (error 6 overflow) in Windows 2000

11. Show vbModal, Me causes Stack Overflow...

12. Show vbModal, Me causes Stack Overflow...

 

 
Powered by phpBB® Forum Software