• DECLARE @TheDateTime DATETIME

    SET @TheDateTime = '20160630 20:21:22'

    SELECT CASE WHEN @TheDateTime = CAST(CAST (@TheDateTime AS NVARCHAR(50)) AS datetime) THEN 'All Correct' ELSE 'Fail!' END [Cast performance],

    CASE WHEN @TheDateTime = CONVERT(DATETIME, CONVERT (NVARCHAR(50), @TheDateTime, 109), 109) THEN 'All Correct' ELSE 'Fail!' END [Convert performance]

    _____________
    Code for TallyGenerator