UFN_EXCHANGEINTEGRATION_CONVERTDATETOENTEREDTIMEZONE

Returns the date converted to the entered time zone if different from system default.

Return

Return Type
datetime

Parameters

Parameter	Parameter Type	Mode	Description
@TIMEZONEENTRYID	uniqueidentifier	IN
@DATE	datetime	IN

Definition

Copy



create function dbo.UFN_EXCHANGEINTEGRATION_CONVERTDATETOENTEREDTIMEZONE
(
    @TIMEZONEENTRYID uniqueidentifier,
    @DATE datetime
)
returns datetime
with execute as caller
as begin
    declare @CONVERTEDDATE datetime;
    declare @DEFAULTTIMEZONE uniqueidentifier;
    set @DEFAULTTIMEZONE = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULT();

    if @TIMEZONEENTRYID <>  @DEFAULTTIMEZONE
    begin
        declare @TIMEZONEOFFSET int;
        set @TIMEZONEOFFSET = dbo.UFN_TIMEZONEENTRY_GETTIMEZONEOFFSETFROMUTC(@TIMEZONEENTRYID, @DATE,1);
        set @CONVERTEDDATE = dateadd(N, - @TIMEZONEOFFSET, @DATE);
    end
    else
    begin
        set @CONVERTEDDATE = @DATE;
    end;

    return @CONVERTEDDATE
end