PHP Date String Format

Question

I have a string mm-dd-yyyy which i get from a form, which i want to store it in the database of the data-type DATE (yyyy-mm-dd).

How do i format the string and save it in the database ?

John Conde · Accepted Answer · 2013-09-27T18:08:09.873

12

$new_format = date("Y-m-d", strtotime('04-28-2012'));

or

$date = new DateTime('04-28-2012');
$new_format = $date->format('Y-m-d');

or in PHP 5.5+

$new_format = (new DateTime('04-28-2012'))->format('Y-m-d');

edited Sep 27 '13 at 18:08

answered Apr 28 '12 at 21:43

John Conde

score 9 · Answer 2 · answered Apr 28 '12 at 21:56

9

Try

$date = DateTime::createFromFormat("m-d-Y", '02-15-2012');
echo  $date->format('Y-m-d H:i:s') , "\n";

Output

2012-02-15 23:54:52

answered Apr 28 '12 at 21:56

Baba

2 Answers2