UFN_DATE_ADDHOURMINUTE

Adds the time in the HourMinute field to the date in the Date field

Return

Return Type
datetime

Parameters

Parameter	Parameter Type	Mode	Description
@GIVENDATE	datetime	IN
@TIMEOFDAY	UDT_HOURMINUTE	IN

Definition

Copy



CREATE function dbo.UFN_DATE_ADDHOURMINUTE
(
    @GIVENDATE datetime,
    @TIMEOFDAY dbo.UDT_HOURMINUTE
) returns datetime
as
begin
    return 
        dateadd
        (
            mi, 
            cast(substring(@TIMEOFDAY, 3, 2) as int), 
            dateadd
            (
                hh, 
                cast(substring(@TIMEOFDAY, 1, 2) as int), 
                @GIVENDATE
            )
        )
end