1 Reply Latest reply on Nov 17, 2017 5:12 PM by Lawrence Nag

    XCenter create_date is ahead by 4 or sometimes 5 hours

    Lawrence Nag

      We have noticed that all xcenter records have incorrect create_date's, most often 4 hours ahead of what would be expected.  This looks to have always been a problem, but more recently have noticed it as it might have an affect on Loyalty backend process that is relying on these date fields.

      Upon further review, it would appear that depending on the location of the stores, the difference between the create_date is based upon the stores timezone.  EST stores off by 4, CST stores off by 5, etc...

       

      Tried query...

      DECLARE @TimeZone VARCHAR(50)

      EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE',

      'SYSTEM\CurrentControlSet\Control\TimeZoneInformation',

      'TimeZoneKeyName',@TimeZone OUT

      SELECT @TimeZone

       

      Result =

      (No column name)

      Eastern Standard Time

       

      Expected result: Please let us know if this issue is a know issue, if not, if there is any recommendation to resolve it.

       

      Xstore version: 7.1.5.13

       

      Please let me know if you need any more details to provide the proper advise.