• It should work

    SELECT COVERT(VARCHAR,GETDATE(),111);