I have a time field in a table that I would like to display in a view in hh:mm format. What is the easiest way to do this?
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