UFN_ITINERARY_ENDDATETIME
Returns the end date and time of a given itinerary.
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITINERARYID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_ITINERARY_ENDDATETIME
(
@ITINERARYID uniqueidentifier
)
returns datetime
with execute as caller
as begin
declare @END datetime;
select @END = max(ENDDATETIME)
from dbo.ITINERARYITEM
where ITINERARYID = @ITINERARYID;
return @END;
end