Home Forums SQL Server 2008 T-SQL (SS2K8) Convert concatenated varchar date and time to datetime RE: Convert concatenated varchar date and time to datetime
oradbguru
Hall of Fame
Points: 3126
More actions
February 7, 2012 at 9:57 am
#1443932
This works fine on my test data but when I try it on actual data, I get the following message:
Msg 242, Level 16, State 3, Line 1The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.