UFN_ITINERARYITEM_ENDDATETIME

Returns an itinerary item's end date time

Return

Return Type
datetime

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYITEMID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_ITINERARYITEM_ENDDATETIME(@ITINERARYITEMID uniqueidentifier)
            returns datetime
            with execute as caller
            as begin

                declare @ENDDATETIME datetime

                select @ENDDATETIME = ENDDATETIME
                from dbo.ITINERARYITEM
                where ID = @ITINERARYITEMID

                return @ENDDATETIME;
            end