I suggest storing a "denormalized UTC time", a calculated column would work fine for that.

For automation: install the latest tz database (I use pytz for this, usually) and then run a batch job to see what's changed. Not trivial but not impossible either. Running events websites is hard!