Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string. code example
Example: Msg 241, Level 16, State 1, Line 12 Conversion failed when converting date and/or time from character string.
DECLARE @Value nVarchar(MAX)='2016-03-01 00:00:00.000000'
SELECT CONVERT(DATETIME,LEFT(@Value,23),101)