Обновление времени

UPDATE datetimes

SET datetime = DATE_ADD(datetime, INTERVAL (15 — HOUR(datetime)) HOUR);

SELECT * FROM `rates` WHERE symbol = ‘EURUSD’ AND TIME(time) = ’07:00:00′

UPDATE `models_results` SET `time` = DATE_ADD(`time`, INTERVAL 1 HOUR) WHERE model_config_id = ‘233’ AND TIME(time) = ’07:00:00′;

SELECT * FROM models_results WHERE model_config_id = ‘233’ AND TIME(time) = ’07:00:00′

SET datetime = DATE_ADD(datetime, INTERVAL (15 — HOUR(datetime)) HOUR);

SELECT * FROM `rates` WHERE symbol = ‘EURUSD’ AND TIME(time) = ’07:00:00′

UPDATE `models_results` SET `time` = DATE_ADD(`time`, INTERVAL 1 HOUR) WHERE model_config_id = ‘233’ AND TIME(time) = ’07:00:00′;

SELECT * FROM models_results WHERE model_config_id = ‘233’ AND TIME(time) = ’07:00:00′