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())