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 ?
    nilayinc, Aug 21, 2003
    #2

  2. SanetteWessels New Member

    In what format is your datefields stored?

    Sanette

    SQL Developer
    JustEnough Software Corporation

    quote:Walking on water and coding of a spec is easy, as long as both are frozen - A friend
    SanetteWessels, Aug 21, 2003
    #2

  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
    Moderator
    SQL-Server-Performance.Com
    satya, Aug 21, 2003
    #2

Share This Page