SQL Server 2008: display time in hh:mm format

Question

In SQL Server, In a table, I have a time field that I need to display in a view in hh:mm format. 

What can be the most simplistic way to do this?

Answer 1

You can use the below code:

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

RESULT:  13:19

For Time values

DECLARE @TimeField TIME = CAST(GETDATE() AS TIME);

SELECT CONVERT(VARCHAR(5), @TimeField, 108)

RESULT:  13:21

Kick-start your career in SQL with the perfect SQL Training Course now!

Watch the below SQL video tutorial to gain more knowledge on SQL...