PHP date() format when inserting into datetime in MySQL

The problem is that you’re using 'M' and 'D', which are a textual representations, MySQL is expecting a numeric representation of the format 2010-02-06 19:30:13

Try: date('Y-m-d H:i:s') which uses the numeric equivalents.

edit: switched G to H, though it may not have impact, you probably want to use 24-hour format with leading 0s.

Related Posts:

  1. How to use mysqli_query() in PHP?
  2. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  3. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  4. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  5. what does “/index.php?admin/admin_dashboard” in my url mean
  6. How can I prevent SQL injection in PHP?
  7. How to create a foreign key in phpmyadmin
  8. If variable equals value php [duplicate]
  9. MySQL – count total number of rows in php
  10. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  11. Foreach only outputs if id is 0
  12. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  13. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  14. How to join two tables by multiple columns in SQL?
  15. SQL – Update multiple records in one query
  16. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  17. mysqladmin: connect to server at ‘localhost’ failed
  18. mysql update multiple columns with same now()
  19. Usage of MySQL’s “IF EXISTS”
  20. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  21. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  22. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  23. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  24. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  25. Deprecated: mysql_query() [duplicate]
  26. CAST to DECIMAL in MySQL
  27. How to stop mysqld
  28. Can I store images in MySQL 
  29. MySQL Daemon Failed to Start – centos 6
  30. How to remove index.php from WordPress site URL
  31. How to use Memcached with PHP7?
  32. select count(*) from table of mysql in php
  33. Set page template for all pages?
  34. is it possible to run some php code within a wordpress page?
  35. Optimize Multiple Taxonomy Term MySQL Query?
  36. WordPress MySQL & PHP Performance
  37. What specific database privileges does WordPress need?
  38. Using source control with WordPress
  39. My WordPress site always displays a cached version of its homepage
  40. Updating User Meta with SQL Query
  41. wpdb prepare syntax
  42. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  43. How to run this SQL query of wp_terms database
  44. Modern Tribe Calendar wp-query with meta query not working at all
  45. Proper way to work with wpdb to get user’s firstname
  46. How to change post format from Aside to Image for all posts?
  47. How to add and SQL query of posts only published
  48. Slow Mysql Queries
  49. can database and media folder be moved to a different drive?
  50. Find duplicate posts with same slug and author
  51. Is the outdated PHP mysql extension a requirement for WordPress 4.6?
  52. writing inner join in wpdb
  53. Why is variable not working on custom sql query using wpdb?
  54. How can I export posts with featured images, without download them
  55. Unknown collation when I import a dump from an existing site into a development database?
  56. PHP script can’t connect to Database on port 3307
  57. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  58. WpDataTables – View Image Directory
  59. Sum the total amount of a specific product purchased per user and display in table
  60. How to translate this mySQL query to $wpdb query
  61. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  62. Separate DB by yearly archive of WordPress
  63. Update MySQL query so that it functions again
  64. Make a database query using WordPress
  65. Query posts by custom taxonomy and sort by post_modified
  66. WordPress $wpdb get posts from category and sort by custom meta
  67. Array Formation Issue
  68. Using wordpress function to retrieve data
  69. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  70. making php value numeric
  71. WordPress $wpdb no result
  72. How to get the custom field value using SQL query
  73. Please help! I have a problem with getting wordpress databas
  74. How to run complex query using PHP
  75. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  76. Conditional formatting on data fetched from MYSQL
  77. Can I split a huge wp_postmeta table across different databases or servers?
  78. edit_user_created_user hook – using to update Groups
  79. Mysql Error in querying form entries in Gravity Form plugin
  80. WP + MySql db / PHP
  81. The plugin generated 225 characters of unexpected output during activation
  82. append data to mysql table via submit button coded in php – not working
  83. WordPress select query issue
  84. Improving performance of SQL sub-queries in WordPress
  85. How to do a MySql query in WordPress?
  86. Send data from plugin to external database
  87. How to set max users to 17.000
  88. directorypress theme error mysql_error() [closed]
  89. Saving custom term value to the database in new table
  90. MySQL errors after a WordPress clone
  91. MYSQL Join on meta key value?
  92. Cannot Upload Custom Header Image into WordPress Dashboard
  93. Complicated MySQL Query
  94. problem with quotes on new post
  95. Predefine Magazine Style Layouts
  96. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
  97. remove wordpress post links
  98. mysqldump to a tar.gz
  99. Where is my mysql log on OS X?
  100. running an existing WordPress site from Visual Studio Code?

Leave a Comment

error code: 523