UFN_JOB_DISPLAYTIME

Returns the displayable time for a start and stop time.

Return

Return Type
nvarchar(20)

Parameters

Parameter	Parameter Type	Mode	Description
@STARTTIME	UDT_HOURMINUTE	IN
@ENDTIME	UDT_HOURMINUTE	IN

Definition

Copy



            create function dbo.UFN_JOB_DISPLAYTIME(@STARTTIME dbo.UDT_HOURMINUTE, @ENDTIME dbo.UDT_HOURMINUTE) returns nvarchar(20) with execute as caller
            as
            begin
                declare @RETVAL nvarchar(20);
                set @RETVAL = '';
                if len(@STARTTIME) > 0
                    set @RETVAL = dbo.UFN_HOURMINUTE_DISPLAYTIME(@STARTTIME)
                else
                    set @RETVAL ='All day';

                if len(@ENDTIME) > 0 
                    set @RETVAL = @RETVAL + ' - ' + dbo.UFN_HOURMINUTE_DISPLAYTIME(@ENDTIME)

                return @RETVAL
            end