Msg 241, Level 16, State 1, Procedure pGetRateCardForBilling, Line 72 [Batch Start Line 2] 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)