Support Article
Date does not change as per the timezone selected
Summary
While extracting data through command line in Business Intelligence Exchange (BIX), user passes timezone ("-J" "Europe/London") as an argument such that the date field gets converted to the required timezone and is extracted accordingly. The application and data base servers are set to Amsterdam timezone. Requirement is to extract the data as per London's time. This works as expected during the daylight saving time (i.e. BST hours which is GMT+1 during the summer time). The timezone must have changed and the date must have converted to GMT dates due to the timezone parameter when the daylight saving period gets over and the GMT starts. However, the date still remains in the BST hours i.e. 1 hour ahead of GMT.
Error Messages
Not Applicable
Steps to Reproduce
- Create a Business Intelligence Exchange (BIX) extract rule on the Designer Studio
- Pass the -J Europe/London parameter in BIX.xml or while running the standalone command
- Verify if the records are being extracted correctly and the Date and Time is as per the timezone
Root Cause
When the timezone is set to Europe or London, Calendar.ZONE_OFFSET is used in ExtractCmdLineArgs.java which is mapped to Jan 01 1970. The timezone of London is UTC+1hr in this case. Hence, the extracted dates are converted to UTC+1 on specifying the Europe or London timezone.
Resolution
Apply HFix-60159.
Published February 10, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.