SBODateTimeToSQLDateTime.sql

CREATE FUNCTION SBODateTimeToSQLDateTime
(	
	@Date datetime, @Time smallint
)
RETURNS datetime
AS
BEGIN
    DECLARE 
	   @Hour smallint = CAST(SUBSTRING(CAST(@Time as varchar(4)), 1, 2) AS smallint),
	   @Minute smallint = CAST(SUBSTRING(CAST(@Time as varchar(4)), 3, 2) AS smallint)

    RETURN DATEADD(MINUTE, @Minute, DATEADD(HOUR, @Hour, @Date))
END