BIX Extract using shell script -u param off by one hour
Developer wants to use the -u and -U parameters in the BIX script to extract cases by pxUpdateDateTime from midnight of a particular day to midnight of another day, using parameters like:
b=1, a=BixUser, U=20160926T235959.999, u=20160926T000000.000, i=PegaSample!Test, p=password
However, the query that is generated for the extract shows, it is actually extracting from 1 am to 1am.
SELECT pzPVStream FROM PEGADATA.your_work_table WHERE pzInsKey like ? AND pxUpdateDateTime >= ? AND pxUpdateDateTime <= ? ORDER BY pzInsKey <2016-09-26 01:00:00.0> <2016-09-27 00:59:59.999>
The server running this is currently using the EDT timezone.
Error MessagesNot applicable
Steps to ReproduceRun a BIX extract from command line and use the -u / -U parameters.
Root CauseA defect in Pegasystems’ code or rules causes the EST timezone to be used by default.
ResolutionPerform the following local-change:
Include the timezone with the -u / -U parameters like "-u 20161012T235959.999 EDT" or "-U 20161012T235959.999 GMT".
Published October 24, 2016 - Updated November 11, 2016