Subtracting an interval from max(date) in MySQL

Question

I have run queries of this sort in postgreSQL and it works:

Select max(date_hour) - interval '2 days' from table

I tried the same in MySQL and also a few permutations and combinations i.e. by removing 's' from days and removing quotes and also tried using 'date_sub' but, it didn't work. Does anything of this sort work in MySQL? Any help would be much appreciated

The SQL standard would be `interval '2' day`, not `'2 days'` — , Jul 25 '14 at 14:18

score 1 · Accepted Answer · answered Jul 25 '14 at 14:12

1

select max(date_hour) - interval 2 day 
from your_table

answered Jul 25 '14 at 14:12

juergen d

201,996
37
293
362

Subtracting an interval from max(date) in MySQL

1 Answers1