• An incomplete answer that generates a syntax error cannot possibly be a correct answer, therefore only option 4 is correct. 😀

    --Method 2:

    --use the internal structure of datetime(2)

    cast(cast(reverse(substring(cast(@t as binary(9)),2,5))

    as binary(5)) as bigint)*100