datetime cast hours minutes

I would like to return only minutes and hours from datetime.
For example GetDate() should return 13:40
How is best to do that?
johnkainnAsked:
Who is Participating?
 
Den_HBRCommented:
SELECT CONVERT(VARCHAR(5), GETDATE(), 108)
0
 
Reza RadConsultant, TrainerCommented:
select Convert(char(2),datepart(Hour,getdate()))+':'+convert(char(2),datepart(MINUTE,getdate()))
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.