Get current time without Date

Question

How do I get the current time only?

select getdate()

Gives me:

Dec 16 2016  5:41PM

I want this result:

5:41PM

Answer 1

You can convert the GETDATE() results to a TIME datatype to pull the current time:

Select Convert(Time, GetDate())