Try this:
SELECT CONVERT(VARCHAR(5),GETDATE(),108) AS Time
SELECT AttDate, CONVERT(VARCHAR(5), AttDate,108) AS Time FROM Table1
OR
SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20), GETDATE(), 100), 7)) AS Time
SELECT AttDate, LTRIM(RIGHT(CONVERT(VARCHAR(20), AttDate, 100), 7)) AS Time FROM Table1
--Amit