Home / Questions / 164926
Accepted
Hoose
Asked: 2020-05-17 07:51:04 +0800 CST 2020-05-17 07:51:04 +0800 CST

Subtract hours from a datetime in MySQL

  • 772

I have a field which is a datetime, this field returns the following date/time:

2018-05-16 14:37:45

What I would like is to be able to subtract 5 hours from that date and have it look like this:

2018-05-16 09:37:45

I was able to achieve it with the function DATE_ADDbut I like to believe that there might be an easier way to achieve what I want. Any other way to achieve it that is easier?

DATE_ADD(ov.hora_llegada, INTERVAL -5 HOUR)
mysql

1 Answers

  1. Best Answer

    MySQL has DATE_SUB() :

    SELECT DATE_SUB(ov.hora_llegada, INTERVAL 5 HOUR)

    And then use it however you want, for example:

    UPDATE prueba SET ov.hora_llegada = DATE_SUB(ov.hora_llegada, INTERVAL 5 HOUR);

    If you want to test it first to make sure it's doing what you want:

    SELECT ov.hora_llegada, DATE_SUB(ov.hora_llegada, INTERVAL 5 HOUR) FROM prueba;
    • 5