What is the correct format to pass to the date() function in PHP if I want to insert the result into a MySQL datetime type column?
I've been trying date("Y-M-D G:i:s") but that just inserts "0000-00-00 00:00:00" everytime.
4
-
date( 'Y-m-d H:i:s', strtotime( $date ) );Blinkydamo– Blinkydamo2016-11-09 14:52:56 +00:00Commented Nov 9, 2016 at 14:52
-
1RTM's php.net/manual/en/function.date.php --- dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.htmlFunk Forty Niner– Funk Forty Niner2016-11-09 14:53:40 +00:00Commented Nov 9, 2016 at 14:53
-
1Possible duplicate of PHP - Insert date into mysqlBourbia Brahim– Bourbia Brahim2016-11-09 14:55:56 +00:00Commented Nov 9, 2016 at 14:55
-
MySQL only support Y-M-DSunil Pachlangia– Sunil Pachlangia2016-11-09 15:16:59 +00:00Commented Nov 9, 2016 at 15:16
Add a comment
|
1 Answer
You have two options on formatting a datetime ready for mysql:
$date = '04 nov 2016 15:59:25';
$one = new DateTime( $date );
echo $one->format( 'Y-m-d H:i:s' );
$two = date( 'Y-m-d H:i:s', strtotime( $date ) );
echo $two;
Providing that the format in the end is 'Y-m-d H:i:s' then you should be good with mysql datetime columns
