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.