I've just switched my localization settings for the Daylight Savings folderol. (Something that, admittedly, I haven't done in previous years.) This year, I have over 200 entries in the queue that had their publish times set - and now, with the DST localization change, the publish time has all been changed. Is there a way to globally change entry times? I was looking at this question on bulk-entry status updating to see if I could figure out a way to tweak things, but I'm admittedly not super-strong on SQL syntax.
The changes I want to make are:
where an entry is in the future, and the time equals 8:15 AM,
change the time to 7:15 AM
Forgot to specify: I'm using EE 2.6x