convert date from string to mysql datetime field

Question

I have a string 31/05/2017

And I want to convert it to MYSQL format, 2017-05-31 00:00:00.
What I have done is.

$dateString = '31/05/2017';
$timestamp = strtotime($dateString);
$date = date("Y-m-d H:i:s", $timestamp);

But strtotime is returning false.

possible solution and similar question to http://stackoverflow.com/questions/2167916/convert-one-date-format-into-another-in-php — Sandeep Garg, Jan 18 '17 at 07:21

score 2 · Accepted Answer · edited May 23 '17 at 12:08

Dates in the m/d/y or d-m-y formats are disambiguated by looking at the separator between the various components: if the separator is a slash (/), then the American m/d/y is assumed; whereas if the separator is a dash (-) or a dot (.), then the European d-m-y format is assumed.

<?php
$dateString = str_replace("/", "-", '31/05/2017');
$timestamp = strtotime($dateString);
var_dump(strtotime($dateString));
echo $date = date("Y-m-d H:i:s", $timestamp);
?>

check below links

http://php.net/manual/en/function.strtotime.php

strtotime returning false date

score 0 · Answer 2 · answered Jan 18 '17 at 07:28

0

Please try Following,

$dateString = '31/05/2017';
$timestamp = strtotime(str_replace('/', '-', $dateString )); 
$date = date("Y-m-d H:i:s", $timestamp);

Thanks.

answered Jan 18 '17 at 07:28

Ramesh

47
5

This answer is missing its educational explanation. – mickmackusa Mar 07 '21 at 02:52

convert date from string to mysql datetime field

2 Answers2