php - 如何在MySQL opencart中将12转换为24

Question

我正在尝试从 OpenCart 中的 MySQL 获取插入时间和分钟相反，当我单击单独保存时，它会始终在上午 12:00 更新输入值

这是查询

$this->db->query("UPDATE " . DB_PREFIX . "delivery_time SET delivery_time_name = '" . $this->db->escape($data['delivery_time_name']) . "', delivery_time_from = 'TIME( STR_TO_DATE( " . $this->db->escape($data['delivery_time_from']) . ", \"%h:%i %p\" ) )', delivery_time_to = '" . $this->db->escape($data['delivery_time_to']) . "', status = '" . (int)$data['status'] . "' WHERE delivery_time_id = '" . (int)$delivery_time_id . "'");

但在 phpmyadmin 上工作相同

UPDATE `oc_delivery_time` SET `delivery_time_name`="Slot2",`delivery_time_from`=TIME( STR_TO_DATE( "9:30 AM", "%h:%i %p" ) ),`delivery_time_to`=TIME( STR_TO_DATE( "12:00 PM", "%h:%i %p" ) ),`status`="1" WHERE `delivery_time_id`="2"

Answer 1

使用 MySQL STR_TO_DATE 或 interval

STR_TO_DATE('1:00 PM', ' %h:%i')+ interval 12 hour

或者尝试这个查询:-

Select STR_TO_DATE('1:00 PM', ' %h:%i')+ interval 12 hour