MySQL: Insert datetime into other datetime field

by

According to MySQL documentation, you should be able to just enclose that datetime string in single quotes, (‘YYYY-MM-DD HH:MM:SS’) and it should work. Look here: Date and Time Literals

So, in your case, the command should be as follows:

UPDATE products SET former_date="2011-12-18 13:17:17" WHERE id=1

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. How to do a batch insert in MySQL
  3. Error in MySQL when setting default value for DATE or DATETIME
  4. Difference between two dates in MySQL
  5. MySQL Query to select data from last week?
  6. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  7. Datetime equal or greater than today in MySQL
  8. How to convert number of week into date?
  9. Set NOW() as Default Value for datetime datatype?
  10. Group mysql query by 15 min intervals
  11. SQL Query to show nearest date?
  12. How to copy a row and insert in same table with a autoincrement field in MySQL?
  13. MySQL Error 1264: out of range value for column
  14. How do I get the ID of multiple inserted rows in MySQL?
  15. How to insert data to MySQL with auto-incremented column(field)?
  16. MySQL INSERT INTO … VALUES and SELECT
  17. MySQL error 1241: Operand should contain 1 column(s)
  18. How to get current date & time in MySQL?
  19. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  20. how to cast the hexadecimal to varchar(datetime)?
  21. MySQL optimizing INSERT speed being slowed down because of indices
  22. Get total hours worked in a day mysql
  23. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  24. “Unknown column in ‘field list'”, but column does exist
  25. Insert and set value with max()+1 problems
  26. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  27. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  28. Mysql Convert Column to row (Pivot table )
  29. Greatest value of multiple columns with column name?
  30. insert data from one table to another in mysql

Leave a Comment