Web Programming Answers

Update SQL Substring For Joomla Event Booking Component Daylight Savings Adjustments

To set event start and end dates back to “normal”:

UPDATE jos_eb_events
SET    event_date = replace(event_date, ’19:00′, ’18:00′)
WHERE  event_date LIKE ‘%19:00%’;

UPDATE jos_eb_events
SET    event_end_date = replace(event_end_date, ’22:00′, ’21:00′)
WHERE  event_end_date LIKE ‘%22:00%’;