Time From Datetime

The following script shows how you can get time from datetime:

select CONVERT(char(8), getdate(), 108) as Time

My Two Cents...