Support Article
BIX process adds one hour after day light saving change
SA-397
SUMMARY
After switch to DST (Daylight Savings Time), the BIX extract process is adding an hour (+1 hr) to the supplied update datetime for extracting the work objects.
ERROR MESSAGES
Not Applicable
STEPS TO REPRODUCE
Use BIX extract update datetime parameters <start date> (-u) and <end date> (-U) to pass date time values based on current system clock with DST.
ROOT CAUSE
As per the BIX engine code design, the 19 characters date format (yyyyMMddTHHmmss.SSS) without a specified/supplied Time zone is only intended for internal development/testing purposes and defaults to "EST" Eastern Standard Time. Since the client system's clock is EDT, BIX engine is adding 1 hour to the supplied date time values as part of default conversion into EST.
RESOLUTION
Recommendation for users of BIX is to always specify the client Time zone alongwith any supplied 19 characters (yyyyMMddTHHmmss.SSS) dateTime parameter values. For example - if the BIX extract rule is being run in EDT (Eastern Daylight Savings Time) then just specify the suffix "EDT" to the 19 characters date time values as "yyyyMMddTHHmmss.SSS EDT".
After switch to DST (Daylight Savings Time), the BIX extract process is adding an hour (+1 hr) to the supplied update datetime for extracting the work objects.
ERROR MESSAGES
Not Applicable
STEPS TO REPRODUCE
Use BIX extract update datetime parameters <start date> (-u) and <end date> (-U) to pass date time values based on current system clock with DST.
ROOT CAUSE
As per the BIX engine code design, the 19 characters date format (yyyyMMddTHHmmss.SSS) without a specified/supplied Time zone is only intended for internal development/testing purposes and defaults to "EST" Eastern Standard Time. Since the client system's clock is EDT, BIX engine is adding 1 hour to the supplied date time values as part of default conversion into EST.
RESOLUTION
Recommendation for users of BIX is to always specify the client Time zone alongwith any supplied 19 characters (yyyyMMddTHHmmss.SSS) dateTime parameter values. For example - if the BIX extract rule is being run in EDT (Eastern Daylight Savings Time) then just specify the suffix "EDT" to the 19 characters date time values as "yyyyMMddTHHmmss.SSS EDT".
Published March 14, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.