• Another interesting way (don't know if I would call it a "good" way):

    SELECT LEFT(RIGHT(CONVERT(CHAR(19),GETDATE(),100),7),2) + RIGHT(RIGHT(CONVERT(CHAR(19),GETDATE(),100),7),2)

    -- BASED ON:

    Select LTRIM(RIGHT(CONVERT(CHAR(19),GETDATE(),100),7))

    edit:

    I say "don't know if I would call it a "good" way" because I don't know if it will perform well. I'm sure other will suggest more efficient ways.