How do I return a datetime as HH:MM in my query output.

Looking to turn a SQL Datetime field to HH:MM no seconds etc.
Who is Participating?
dbeneitConnect With a Mentor Commented:
select convert(varchar(5),getdate(),114)
replace getdate() for your field
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.