March 1, 2012 at 11:38 am
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
March 1, 2012 at 11:46 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply