How-To: wpdb Insert Record With Date

date does not take a human readable string. It takes a Unix timestamp. You need to convert that human date to a timestamp with strtotime.

'begin_date'   => date('Y-m-d', strtotime('2012-08-14')),

Of course, there is really no need to convert a YEAR-MONTH-DAY date into a timestamp only to convert it back that a YEAR-MONTH-DAY format.

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  3. How to use $wpdb to delete in a custom table
  4. Matching database content types to PHP types
  5. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  6. Saving custom form data into database
  7. Get data from database table by post_id to get data from second database table
  8. wp-content/db.php : where is this file?
  9. Delete/replace img tags in post content for auto published posts [closed]
  10. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  11. $wpdb->get_results() returns good result only in first foreach iteration
  12. $wpdb->insert – inserting multiple rows
  13. $wpdb prepared with search term
  14. WPDB->insert with special characters
  15. What does wp_update_post() do that the $wpdb class does not?
  16. Is there a (better) way to access $wpdb results?
  17. How to pass NULL in where array for $wpdb->update
  18. Get random row from custom table
  19. store custom WP table names in a global variable
  20. I am not understandinhg $wpdb->prepare correctly
  21. I want to update my postcontent with $wpdb
  22. How to save html and text in the database?
  23. XOR functionality for meta_query
  24. $wpdb->replace / Replace or update primary key
  25. Create an array with a string key from wpdb->get_results
  26. Replicating the WP_Query ‘s’ param with $wpdb
  27. get the number of queries made on a page(inside my plugin)
  28. Doing a loop with multiple DBs simultaneoulsy
  29. Using WPDB class
  30. How can I migrate mysql_fetch_array to $wbpdb?
  31. What is _transient_random_seed for?
  32. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  33. Modify the structure of data returned by $wpdb
  34. wpdb get_results() and prepare when to use prepare?
  35. WPDB If primary key already exists, add +1 to integer field
  36. How to get an array of user roles with or without a specific capability?
  37. Programmatically Creating Page using $wpdb and getting 404 error
  38. Return XML of Post Metadata
  39. Problem in inserting row to custom database table
  40. sanitize_text_field and apostrophe problem
  41. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  42. 301 Redirect Code
  43. wpdb updating record in wordpress with json adds extra array elements
  44. How to display a specific category using a custom Query?
  45. $wpdb->insert inserting only f character in custom table
  46. AWS Bitnami WordPress – SELECT command denied to user
  47. WPDB Placeholders and second argument for prepared statements
  48. PHP Fatal Error – $wpdb a non-object?
  49. Why does wpdb->update delete other meta?
  50. Increment integer field in database when WHERE needs to be dynamic [closed]
  51. Getting variable from Database
  52. How do I count columns on a custom WPDB query?
  53. Custom $wpdb returns unexpected time based results
  54. Trouble inserting string containing quotations marks with wpdb in save_post hook
  55. $wpdb->prepare was called incorrectly when inserting multiple records
  56. How to protect a script execution on WordPress?
  57. how to connect to another database in wordpress
  58. $wpdb->insert() doesnt work anymore
  59. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  60. Save sql file after doing insert wpdb
  61. Perform a function when a user clicks register button
  62. Can I use wpdb to insert query results into a post?
  63. WPDB Query Question with Category Only
  64. $wpdb->prepare error after WordPress update [duplicate]
  65. $wpdb->num_rows doesn’t work
  66. $wpdb->get_var next var?
  67. How do I modify this wpdb query to include posts that have a post_status of publish and draft?
  68. Can’t find out why dbDelta dosen’t create my table
  69. How to pass an input value into wpdb->Prepare
  70. Limit left join
  71. Check if Value Exists in Database, adding row details to variables and echoing result
  72. wpdb replace returning 1 where delete and insert is expected
  73. wpdb discards duplicate column names?
  74. update_post_meta not working in template_redirect action
  75. Get records from Formidable Table using $wpdb->get_col
  76. WPDB SQL query SELECT from category
  77. How to work with constraints on wordpress user metadata?
  78. How to Update multiple rows using $wpdb->update
  79. Unable to use $wpdb in WordPress
  80. How to display specific data from custom database table in WordPress
  81. Get 3 row ID’s via ARRAY_A
  82. Getting record from three wpdb tables
  83. Missing argument 2 for wpdb::prepare() [duplicate]
  84. Why is an empty result an error? ( $wpdb->get_row )
  85. get_row returns empty when data exists
  86. wpdb->update update the entire table instead of one row
  87. wpdb insert working in one function, but not another
  88. How to set up prepared query using IN statement
  89. Save customizer default values to DB on theme activation
  90. Plugin with connection to database – Single function
  91. Alter the main search query to search posts by coauthor user name
  92. WPDB Prepared Delete
  93. wpdb select from using array as search parameters
  94. wpdb Cannot Access Associative Array Data in a Count Query
  95. Can’t get expected result from a wpdb query
  96. Can’t seem to get set_blog_id working, it just doesn’t reset the blog ID
  97. selecting row using wpdb which contain special symbols
  98. Query Problem in Clustom Plugin
  99. How does $wpdb->get_var work with offset?
  100. WP Recommended Table Exclusions?