UFN_ITINERARY_STARTDATETIME
Returns the start 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_STARTDATETIME
(
@ITINERARYID uniqueidentifier
)
returns datetime
with execute as caller
as begin
declare @START datetime;
select @START = min(STARTDATETIME)
from dbo.ITINERARYITEM
where ITINERARYID = @ITINERARYID;
return @START;
end