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.

Lawrence Nag

Please provide your valuable input.