Convert date in format MM/DD/YYYY to MySQL date

Question

I have a PHP function that gets passed a date in the format MM/DD/YYYY I need to then convert this so that it can be added to a MySQL field that is of type date

How would I go about doing this in PHP?

@Amal Murali Not yet no as I couldnt find anything on converting it, and am not sure what formats MySQL date will accept — DevWithZachary, Oct 18 '13 at 21:12

score 29 · Accepted Answer · answered Oct 18 '13 at 21:12

29

$newvalue = date('Y-m-d', strtotime($originalvalue));

answered Oct 18 '13 at 21:12

Mattt

1,780
14
15

score 7 · Answer 2 · edited Jul 06 '15 at 05:44

7

MySQL displays the DATE type as 'YYYY-MM-DD', so you could do something like:

date("Y-m-d",strtotime("10/18/2013"));

edited Jul 06 '15 at 05:44

Saty

22,443
7
33
51

answered Oct 18 '13 at 21:24

PaulV

81
1

thank you! it worked for me even with PHP7 – Tushar Niras Mar 14 '17 at 06:28

score 4 · Answer 3 · answered Oct 18 '13 at 21:23

4

My variant:

  $mysql_date = date('Y-m-d', strtotime(str_replace('/','-', $value)));

answered Oct 18 '13 at 21:23

CreatoR

1,654
10
14

I think php `strtotime()` is smart enough to convert the string to time, even with the `/`, so you don't really have to do str_replace – Oniya Daniel Nov 24 '16 at 09:14
1

@OniyaDaniel, what you are saying is not working with php 5.6, so I had to use this answer to see it working – pollux1er May 13 '18 at 23:26
Ok, that's great! – Oniya Daniel May 14 '18 at 02:48

score 1 · Answer 4 · answered Oct 18 '13 at 21:23

1

$date = preg_replace('/(\d{2})\/(\d{2})\/(\d{4})/', '$3-$1-$2', $date)

answered Oct 18 '13 at 21:23

dewil

19
4

Convert date in format MM/DD/YYYY to MySQL date

4 Answers4

Linked