How do I minus 2 hours from a date/time field in EVERY record in a table?

Question

I'm trying to offset a timezone error from PHP. All times recorded in table 'test' was ahead by two hours. What I want is to update each record by minusing two hours from the time that is already there.

I tried:

UPDATE test 
   SET LastModifiedDate = SUBTIME( LastModifiedDate, '02:00:00' ) 

But this just updates all fields with the same value.

Please assist

tthanks

Answer 1

update test set LastModifiedDate = LastModifiedDate - interval 2 hour;