MySQL add 12 hours to a time field

by

Try using ADDTIME instead of DATE_ADD. You could do SET start_time = ADDTIME(start_time, '12:00:00')

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Compare two MySQL databases [closed]
  3. MySQL – Trigger for updating same table after insert
  4. How do I get the current time zone of MySQL?
  5. Storing image in database directly or as base64 data?
  6. Implementation of Levenshtein distance for mysql/fuzzy search?
  7. Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?
  8. How to get the difference in years from two different dates?
  9. Restore table structure from frm and ibd files
  10. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  11. UNION query with codeigniter’s active record pattern
  12. MySQL grant all privileges to database except one table
  13. Writing optional parameters within stored procedures in MySQL? [duplicate]
  14. mysql stored procedure that calls itself recursively
  15. MySql views performance [closed]
  16. Restore the mysql database from .frm files
  17. When to use NULL in MySQL tables
  18. Mysql insert random datetime in a given datetime range
  19. How to get number of rows affected, while executing MySQL query from bash?
  20. Detecting locked tables (locked by LOCK TABLE)
  21. MySQL UPDATE syntax with multiple tables using WHERE clause
  22. How does MySQL Auto Increment work?
  23. mysql – Dynamic column alias
  24. MySQL Fulltext Search Score Explained
  25. connecting MySQL server to NetBeans
  26. How to start MySQL server from command line on Mac OS Lion?
  27. Autostart MySQL Server on Mac OS X Yosemite/El Capitan
  28. MySQL ‘select for update’ behaviour
  29. Deleting a row based on the max value
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment