Formatting time variable in SQL Server

A colleague of mine recently had an issue when trying to format a variable of the time data type. He was trying to return the time in the HH:mm format and was using the following code: DECLARE @Time TIME = ’13:05′ DECLARE @DateTime DATETIME = ‘20170413 13:05’ SELECT ‘Time’ AS Variable, @Time as Unformatted, FORMAT(@Time,’HH:mm’) […]