• Different method

    DECLARE @Bitbucket CHAR(10);

    SET STATISTICS TIME ON;

    SELECT @Bitbucket = substring(convert(varchar(100), SomeDate,13) , 4,8)

    FROM dbo.JBMTest

    SET STATISTICS TIME OFF;

    and results:

    CPU time = 1078 ms, elapsed time = 1073

    Tiempo de CPU = 1047 ms, tiempo transcurrido = 1042 ms.

    CPU-Zeit = 1062 ms, verstrichene Zeit = 1056 ms.