Posted on : 18-02-2012 | By : caroline | In : Joomla, Joomla Programmer
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%’;
0