• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • Last Modified:

minus 543 year in mysql

ColumnA format is date time how can i update it by minus 543 year
0
teera
Asked:
teera
1 Solution
 
johanntagleCommented:
update table set ColumnA=date_add(ColumnA, interval -543 year);

See http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-add for more information
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now