SQL Server does not have a format that formats the time to hh:mm AM/PM or just hh:mm without the seconds. Is there a way to use code in a stored procedure to display just the hh:mm without the seconds?