I have a table with a timestamp field called "time".
I have many records in this table and "time" has value like: 1343296642, 1343308689...
I need to run a query to subtract 2 years of time to those value.
Can I do this.
Perhaps this UPDATE may do it:
UPDATE tablename SET `time` = `time` - INTERVAL 2 YEAR;
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
3 years ago