convert date string to mysql datetime field

by

First, convert the string into a timestamp:

$timestamp = strtotime($string);

Then do a

date("Y-m-d H:i:s", $timestamp);

More Related Contents:

  1. If number have inside number string [closed]
  2. recurring system my sql query [closed]
  3. Php date() Date and time is stuck [closed]
  4. Cannot modify header information [duplicate]
  5. inserting information and image in php and mysql
  6. CodeIgniter – foreach loop
  7. mysqli or die, does it have to die?
  8. Project Links do not work on Wamp Server
  9. PHP/MySQL insert row then get ‘id’
  10. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  11. Using Jquery Ajax to retrieve data from Mysql
  12. PHP file cannot enter some part of code
  13. Laravel migration: unique key is too long, even if specified
  14. Laravel: PDOException: could not find driver
  15. Laravel Eloquent select all rows with max created_at
  16. MySQL – count total number of rows in php
  17. Advantages Of MySQLi over MySQL [closed]
  18. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  19. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  20. What does a successful MySQL DELETE return? How to check if DELETE was successful?
  21. Grouping WHERE clauses in Codeigniter
  22. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  23. check if the query results empty row mysqli [duplicate]
  24. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  25. double results in my array ( mysql_fetch_array )
  26. How best to get someone’s ‘rank’ from a scores table with php and mysql without looping
  27. php:Store image into Mysql blob, Good or bad?
  28. Connect to remote MySQL server with SSL from PHP
  29. Using MySQL’s TIMESTAMP vs storing timestamps directly
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment