UFN_HOURMINUTE_DISPLAYTIME

Returns the displayable time for a HOURMINUTE values.

Return

Return Type
nvarchar(8)

Parameters

Parameter	Parameter Type	Mode	Description
@TIME	UDT_HOURMINUTE	IN

Definition

Copy



            CREATE function dbo.UFN_HOURMINUTE_DISPLAYTIME(@TIME dbo.UDT_HOURMINUTE) returns nvarchar(8) with execute as caller
            as
            begin
                declare @RETVAL nvarchar(8);
                set @RETVAL = '';
                if len(@TIME) = 4
                    set @RETVAL = replace(replace(ltrim(right(convert(datetime, left(@TIME, 2) + ':' + right(@TIME, 2)), 7)), 'AM', ' AM'), 'PM', ' PM');

                return @RETVAL
            end