SQL Server Performance

Datetime related error

Discussion in 'General Developer Questions' started by nilayinc, Aug 21, 2003.

  1. nilayinc New Member

    I occassionally get this error message : Difference of two datetime fields caused overflow at runtime.
    I have used DATEDIFF in my SP and have declared the result variable as int.
    Have also tried converting the DATEDIFF to float.

    Any ideas ?
  2. SanetteWessels New Member

    In what format is your datefields stored?


    SQL Developer
    JustEnough Software Corporation

    quote:Walking on water and coding of a spec is easy, as long as both are frozen - A friend
  3. satya Moderator

    Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. The result of the DATEDIFF function may be too large.

    Satya SKJ

Share This Page