how to convert the date format while storing in phpmyadmin from the page

Question

How to change the normal input date format dd-mm-yyyy in the webpage to yyyy-mm-dd while storing in the php my admins

possible duplicate of [Convert one date format into another in PHP](http://stackoverflow.com/questions/2167916/convert-one-date-format-into-another-in-php) — GautamD31, Oct 27 '14 at 10:08

score 3 · Accepted Answer · answered Oct 27 '14 at 10:09

3

you can convert the date with strtotime();

  $dateToday = date("d-m-Y");
    $newDate = date("Y-m-d", strtotime($dateToday));

And then you can store data to your database.

answered Oct 27 '14 at 10:09

Akhil Clement

score 2 · Answer 2 · answered Oct 27 '14 at 10:13

2

Although you can use strtotime, I much prefer DateTime object.

//The second parameter being the string from the database.
$date = DateTime::createFromFormat('d-m-Y', '27-10-2014');
echo $date->format('Y-m-d');

answered Oct 27 '14 at 10:13

ʰᵈˑ

2 Answers2