Forum Stats

  • 3,839,864 Users
  • 2,262,546 Discussions
  • 7,901,086 Comments

Discussions

XCenter create_date is ahead by 4 or sometimes 5 hours

Lawrence Nag
Lawrence Nag Member Posts: 2 Red Ribbon
edited Nov 17, 2017 12:12PM in Java USA Tour

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.

Answers