Skip to content
Advertisement

Get current time without Date

How do I get the current time only?

select getdate()

Gives me:

Dec 16 2016  5:41PM

I want this result:

5:41PM

Advertisement

Answer

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

Select Convert(Time, GetDate())
User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement