how to subtract 12 hours 30 minutes from the MySQL from date field

Question

I have reduce or subtract 12 hours 30 minutes from the 2011-04-26 05:00:00(in the format YYYY-MM-DD HH:MM:SS) IN MySQL database.

The output should be 2011-04-25 16:30:00.

Are there any date function we can use and subtract?

Answer 1

DATE_SUB(`date`,INTERVAL '12:30' HOUR_MINUTE)

Checkout date and time functions of mysql

Answer 2

select '2011-04-26 05:00:00' - interval 12 * 60 + 30 minute