USP_EXCHANGEEMAILBATCH_COVERTDATETIMETOSYSTEMDEFAULTTIMEZONE

Parameters

Parameter Parameter Type Mode Description
@DATEUTC datetime IN
@DATESYSTEMTIME datetime INOUT

Definition

Copy


    create procedure dbo.USP_EXCHANGEEMAILBATCH_COVERTDATETIMETOSYSTEMDEFAULTTIMEZONE
    (
        @DATEUTC datetime,
        @DATESYSTEMTIME datetime = null output 
    )
    as
    begin
         declare @TIMEZONEENTRYID_DEFAULT uniqueidentifier = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULT();
       set @DATESYSTEMTIME = dbo.UFN_EXCHANGEINTEGRATION_CONVERTDATETOSYSTEMTIMEZONE(@TIMEZONEENTRYID_DEFAULT, @DATEUTC);
    end