MySQL – How to parse a string value to DATETIME format inside an INSERT statement?

by

Use MySQL’s STR_TO_DATE() function to parse the string that you’re attempting to insert:

INSERT INTO tblInquiry (fldInquiryReceivedDateTime) VALUES
  (STR_TO_DATE('5/15/2012 8:06:26 AM', '%c/%e/%Y %r'))

More Related Contents:

  1. MySQL: Insert datetime into other datetime field
  2. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  3. How to set initial value and auto increment in MySQL?
  4. How to do a batch insert in MySQL
  5. Error in MySQL when setting default value for DATE or DATETIME
  6. LAST_INSERT_ID() MySQL
  7. MySQL Query to select data from last week?
  8. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  9. Timestamp with a millisecond precision: How to save them in MySQL
  10. How to select date from datetime column?
  11. How to convert number of week into date?
  12. Set NOW() as Default Value for datetime datatype?
  13. SQL Query to show nearest date?
  14. How to subtract hours from a datetime in MySQL?
  15. Object of class DateTime could not be converted to string
  16. How to copy a row and insert in same table with a autoincrement field in MySQL?
  17. MySQL Error 1264: out of range value for column
  18. BULK INSERT in MYSQL
  19. Importing a CSV to MySQL with different date format
  20. How to insert data to MySQL with auto-incremented column(field)?
  21. How to insert values in table with foreign key using MySQL?
  22. MySql difference between two timestamps in days?
  23. MySQL error 1241: Operand should contain 1 column(s)
  24. How to get current date & time in MySQL?
  25. MySQL Insert & Joins
  26. How to add a where clause in a MySQL Insert statement?
  27. how to cast the hexadecimal to varchar(datetime)?
  28. MySQL optimizing INSERT speed being slowed down because of indices
  29. “Unknown column in ‘field list'”, but column does exist
  30. Insert and set value with max()+1 problems

Leave a Comment