sql - Get Hours and Minutes (HH:MM) from date

Question

I want to get only hh:mm from date.

How I can get this?

I have tried this :

CONVERT(VARCHAR(8), getdate(), 108)

question from:https://stackoverflow.com/questions/14374822/get-hours-and-minutes-hhmm-from-date

Answer 1

Just use the first 5 characters...?

 SELECT CONVERT(VARCHAR(5),getdate(),108)