--date-time: remove daylight savings offset from db datetimes
UPDATE exgoal SET startdt = startdt+[DAYLIGHT_OFFSET] WHERE startdt>[DT_FROM] AND startdt<[DT_TO];
UPDATE exgoal SET shortdt = shortdt+[DAYLIGHT_OFFSET] WHERE shortdt>[DT_FROM] AND shortdt<[DT_TO];
UPDATE exgoal SET longdt = longdt+[DAYLIGHT_OFFSET] WHERE longdt>[DT_FROM] AND longdt<[DT_TO];
--
UPDATE msrgoal SET startdt = startdt+[DAYLIGHT_OFFSET] WHERE startdt>[DT_FROM] AND startdt<[DT_TO];
UPDATE msrgoal SET shortdt = shortdt+[DAYLIGHT_OFFSET] WHERE shortdt>[DT_FROM] AND shortdt<[DT_TO];
UPDATE msrgoal SET longdt = longdt+[DAYLIGHT_OFFSET] WHERE longdt>[DT_FROM] AND longdt<[DT_TO];
--
UPDATE exlog SET tmstart = tmstart+[DAYLIGHT_OFFSET] WHERE tmstart>[DT_FROM] AND tmstart<[DT_TO];
UPDATE exlog SET tmend = tmend+[DAYLIGHT_OFFSET] WHERE tmend>[DT_FROM] AND tmend<[DT_TO];
--
UPDATE wmove SET tmstart = tmstart+[DAYLIGHT_OFFSET] WHERE tmstart>[DT_FROM] AND tmstart<[DT_TO];
UPDATE wmove SET tmend = tmend+[DAYLIGHT_OFFSET] WHERE tmend>[DT_FROM] AND tmend<[DT_TO];
--
UPDATE msrpic SET dt = dt+[DAYLIGHT_OFFSET] WHERE dt>[DT_FROM] AND dt<[DT_TO];
--
UPDATE OR IGNORE exlog SET dt = dt+[DAYLIGHT_OFFSET] WHERE dt>[DT_FROM] AND dt<[DT_TO];
UPDATE OR IGNORE exlogset SET dt = dt+[DAYLIGHT_OFFSET] WHERE dt>[DT_FROM] AND dt<[DT_TO];
UPDATE OR IGNORE wklog SET dt = dt+[DAYLIGHT_OFFSET] WHERE dt>[DT_FROM] AND dt<[DT_TO];
UPDATE OR IGNORE msr SET dt = dt+[DAYLIGHT_OFFSET] WHERE dt>[DT_FROM] AND dt<[DT_TO];
