DateTime INSERT UPDATE

Set value to Now +- time period

"UPDATE MyDateTimeColumn = DATE_SUB(Now(), INTERVAL 90 SECOND)"
"UPDATE MyDateTimeColumn = DATE_ADD(Now(), INTERVAL 90 SECOND)"

Argument can be:

  • MICROSECOND
  • SECOND
  • MINUTE
  • HOUR
  • DAY
  • WEEK
  • MONTH
  • QUARTER
  • YEAR