Get Started with Redwood for Oracle Cloud HCM Begin Now
How to load OTL ScheduleShiftEvent when the timezone offset changes
I'm using HDL Loader as follows:
MERGE|ScheduleShiftEvent|ASCHR01G_19200008_1_10142434|576273|576273|19200008_576273|CREATE|2027/03/27|2027-03-27T20:00:00.000+00:00|2027-03-28T07:00:00.000+01:00||0|CUSTOMTIME|WORK|TIME|Y
The timezone offsets are different for the start and end dates due to this particular shift being loaded in the period when the clocks change.
The error i receive is:
Error 1 : You need to use the same format for the shift start and end times.
If the two timezone offsets are in sync then it works fine. 2027-03-27T20:00:00.000+00:00|2027-03-28T07:00:00.000+00:00
Does anyone know how to load shifts when the clocks change!?
0