UFN_EXCHANGEINTEGRATION_CONVERTDATETOSYSTEMTIMEZONE
Returns the date converted to the system default time zone, if entered time zone is different from system default.
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TIMEZONEENTRYID | uniqueidentifier | IN | |
| @UTCDATE | datetime | IN |
Definition
Copy
create function dbo.UFN_EXCHANGEINTEGRATION_CONVERTDATETOSYSTEMTIMEZONE
(
@TIMEZONEENTRYID uniqueidentifier,
@UTCDATE datetime
)
returns datetime
with execute as caller
as begin
declare @CONVERTEDDATE datetime;
declare @TIMEZONEOFFSET int;
set @TIMEZONEOFFSET = dbo.UFN_TIMEZONEENTRY_GETTIMEZONEOFFSETFROMUTC(@TIMEZONEENTRYID, @UTCDATE,1);
set @CONVERTEDDATE = dateadd(N, @TIMEZONEOFFSET, @UTCDATE);
return @CONVERTEDDATE
end