PHP formatting data string to MySQL date format

Question

I have this string I'm getting from the GUI: 09/22/2012 (mm/dd/yyyy).

I want to format it to:

date("Y-m-d");  //(the MySQL DATE format )

What should be the right PHP date function parameters to do so?

@Baba I think he means "What should be the right parameters for the php date function" ("shell" is probably a typo for "shall"). — Barmar
– Barmar, Commented Sep 22, 2012 at 20:24

Baba · Accepted Answer · 2012-09-22 20:13:55Z

1

You can try

$date = DateTime::createFromFormat("m/d/Y", "09/22/2012");
echo $date->format("Y-m-d");

Output

2012-09-22

answered Sep 22, 2012 at 20:13

Baba

95.3k29 gold badges172 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

This solution is better than the other one given.

David · Accepted Answer · 2012-09-22 20:32:04Z

1

You can also do the following to get the MySQL date format.

echo date('Y-m-d', strtotime('09/22/2012'));
// Output: 2012-09-22

Hope that helps.

answered Sep 22, 2012 at 20:32

David

2,0752 gold badges17 silver badges27 bronze badges