SQL 2008 Leap year issue?

  • I have an insert stored procedure that uses convert function to convert varchar() to datetime. The stored procedure has been running for years without problem except YESTERDAY (2/29/2012).

    strSQL: EXEC StoredProcedureName '182866', 'ExtractMMS', '2/29/2012 11:34:18 PM',

    'Error: The statement has been terminated.~The conversion of a varchar data type\

    to a datetime data type resulted in an out-of-range value.~Msg 242, Level 16, \

    State 3, Server FACETS471, Procedure StoredProcedureName, Line 35~',

    '8' failed with critical error flag: 1

    The stored procedure failed at 11:34:18 PM but re-run successfully after mid-night (3/1).

    Is that a LEAP year problem? Do you see any MS document report this problem?

    Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply