UPDATE tbloptions SET value = 'd M Y|%d %b %Y' WHERE name = 'dateformat';
UPDATE tblapad_options SET value = 'd M Y|%d %b %Y' WHERE name = 'dateformat';
UPDATE tbloptions_static SET value = 'd M Y|%d %b %Y' WHERE name = 'dateformat';

UPDATE tbloptions SET value = '24' WHERE name = 'time_format';
UPDATE tblapad_options SET value = '24' WHERE name = 'time_format';
UPDATE tbloptions_static SET value = '24' WHERE name = 'time_format';