UFN_ITINERARYITEM_STARTDATETIME

Returns an itinerary item's start date time

Return

Return Type
datetime

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYITEMID	uniqueidentifier	IN

Definition

Copy



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

                declare @STARTDATETIME datetime

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

                return @STARTDATETIME;
            end