UFN_EXCHANGEINTEGRATION_GETTIMEFROMDATE
Returns a UDT_HOURMINUTE that represents the time for a given date.
Return
| Return Type |
|---|
| UDT_HOURMINUTE |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATE | datetime | IN |
Definition
Copy
CREATE function dbo.UFN_EXCHANGEINTEGRATION_GETTIMEFROMDATE
(
@DATE datetime
)
returns UDT_HOURMINUTE
with execute as caller
as
begin
declare @HOUR as nvarchar(2)
declare @MIN as nvarchar(2)
set @HOUR = cast(datepart(hh, @DATE) as nvarchar(2))
set @MIN = cast(datepart(n, @DATE) as nvarchar(2))
return replicate('0', 2 - len(@HOUR)) + @HOUR + replicate('0', 2 - len(@MIN)) + @MIN
end