User set date and time from frontend doesn’t get stored into database

Got it to work by formatting the $dateAndTime string like this before binding it:

$formattedDateAndTime = date("Y-m-d H:i:s", strtotime($dateAndTime));

Related Posts:

  1. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  2. How do I join a $wpdb query with user meta using default value if not exist?
  3. Copyright: Get first and last date of post type
  4. How to convert a string to date in MySQL?
  5. MySQL date formats – difficulty Inserting a date
  6. How to use greater than operator with date?
  7. How do you properly prepare a %LIKE% SQL statement?
  8. $wpdb and MySQL Create Trigger
  9. wpdb->prepare function remove single quote for %s in SQL statment
  10. Alternative to mysql_real_escape_string
  11. Increment value (value = value+1) of $wpdb->update
  12. SQL query to update post_date (one post = one single date & time)
  13. wpdb Custom Meta Data with 2 conditions
  14. wpdb prepare syntax
  15. SQL query not working in alphabetical post title/content search
  16. MySQL LIKE not working
  17. Proper way to work with wpdb to get user’s firstname
  18. How to check for empty and not a failure
  19. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  20. Database: Custom table: sprintf value for DateTime column
  21. Converting mysql to $wpdb
  22. WP_USE_EXT_MYSQL
  23. wpdb insert and boolean fields
  24. Join new table with SQL query
  25. writing inner join in wpdb
  26. How to split the a table in database?
  27. MySQL Rank & $wpdb
  28. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  29. How to translate this mySQL query to $wpdb query
  30. $wpdb select all meta for each post
  31. $wpdb to insert html form information
  32. Proper usage of $wpdb->update()?
  33. WordPress(wpdb class) and mysql stored procedures
  34. Can’t run database query
  35. Using WPDB->Insert()
  36. Active DB queries in WordPress?
  37. How to stop $wpdb from prepending database name
  38. WordPress $wpdb get posts from category and sort by custom meta
  39. How to get INSERT errors from $wpdb?
  40. Getting Error Trying to Create Table
  41. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  42. Understanding custom php that reads from WP MYSQL
  43. How to insert dash (-) into database using wpdb and new_to_publish hook?
  44. $wpdb->get_var multiple queries in one database check
  45. List users with the most posts in the last 30 days
  46. Insert two row in wordpress database
  47. WordPress $wpdb no result
  48. PHP variables in mysql query
  49. MySQL ‘duplicate entry’ error
  50. Wpdb query with dynamic table name
  51. get posts whether meta_key exists or not
  52. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  53. How to search usermeta table
  54. How to add virtual column in wpdb get_result statement
  55. wpdb insert into point column in db
  56. WPDB delivers wrong results from complex queries
  57. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  58. CONCAT_WS in custom sql query
  59. Geographical proximity query using post_meta
  60. MySQL Select within WP Page template
  61. Saving custom term value to the database in new table
  62. why is $wpdb->update() causing a DB error from within wp_set_password()
  63. $wpdb->get_var returns 0
  64. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  65. MySQL IF NOT NULL, then display 1, else display 0
  66. Get the new record primary key ID from MySQL insert query?
  67. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  68. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  69. Remove Primary Key in MySQL
  70. How to get the max of two values in MySQL?
  71. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  72. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  73. Get date of last update outside of loop
  74. query to create woocommerce products from images
  75. Date query not inclusive despite parameter being true
  76. wp query foreach deleting record returning only first or last item
  77. mySQL statment count of post in each category and sub category
  78. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  79. Paypal Post IPN handeling nightmare
  80. Is there a page length limit?
  81. Create a form with custom autocomplete address field and CSV import values
  82. WordPress insert query is not working : Showing no Error
  83. Some Post Content Does Not Show Up In DB Search
  84. Help setting up a sql query
  85. How can I view my site directly from WordPress dashboard?
  86. (WP List Table) How to sort by SKU and Custom Fields?
  87. Using wpdb to connect to a different database is not working
  88. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  89. Can’t add to time? [closed]
  90. Timezone for Plugin
  91. How do I insert content of various MySQL fields in post?
  92. Query does not filter duplicate _sku numbers
  93. wp_postmeta – lot of meta fields
  94. MySQL: get post_tag items that are tags (not SEO keywords)
  95. cannot log in to the mysql server (wamp and wordpress)
  96. InnoDB: Error: log file ./ib_logfile0 is of different size
  97. Postgres equivalent to MySQL’s \G?
  98. Convert custom field date format to “WordPress default”
  99. Putting form result in my database
  100. How can I update a value of a field depending on outside source?