Support Article
-J option in BIX does not handle both daylight and standard time
SA-19720
Summary
When extracting WO to database table the JDBC driver converts datetime properties to the corresponding timezone of the database. This conversion handles daylight savings time and standard time in the same WO.
When extracting WO to XML the output is giving for datetime properties in GMT. The -J option was added to allow for conversion of datetime properties by an UTC offset, eg, UTC-6:00. This works if all of the datetime properties in the WO are in either daylight savings or standard time. However, if a WO has a pxCreateDateTime for example of 10/31/2013 10:00 PM CDT and a pxUpdateDateTime of 11/5/2013 5:00 am CST there is no way to set the -J offset to handle both conversions correctly.
Error Messages
Not applicable
Steps to Reproduce
Have WO with two datetime properties - one from CDT and one from CST. Run extract with -J option and observe the datetime properties of each.
Root Cause
A defect or configuration issue in the operating environment. Instead of setting the timezone in the -J parameter to either UTC-6:00 or UTC-5:00 set it to a timezone which understands both daylight savings and standard time.
Resolution
Make the following change to the operating environment: Run the extraction with -J CST6CDT or -J America/Chicago for the conversion of datetime properties to the correct CST or CDT time.
Published February 13, 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.