Convert date format from d M yy to yyyy-mm-dd

Asked Dec 14 '18 at 09:26

Active Dec 14 '18 at 10:02

Viewed 28 times

I know that there are million questions on here about converting dates in PHP, but none seems to suit my situation.

I would like to convert an array of dates that looks like this:

Array (
   [0] => 1 Dec 2018
   [1] => 2 Dec 2018 
   [2] => 3 Dec 2018 
)

...into yyyy-mm-dd format. It seems that strtotime() cannot convert M to m, even though it should be able to do this....

The original format above is coming from a UI and cannot be changed. I therefore have not choice but to convert it.

Here is what I have:

$date // this is the original array, in '1 Dec 2018' format

$formatted_date = array();

for ($i=0; $i<count($date); $i++) {
    $formatted_date[] = date("yyyy-mm-dd", strtotime($date));
}

From this, the output is

Array ( 
    [0] => 70707070-0101-0101 
    [1] => 70707070-0101-0101
    [2] => 70707070-0101-0101 
)

edited Dec 14 '18 at 10:02

executable

3,365
6
24
52

asked Dec 14 '18 at 09:26

Paul Clift

1

Try using `date('Y-m-d', strtotime($date))` – Christhofer Natalius Dec 14 '18 at 09:28
I knew that it's be something dead simple like that :-) – Paul Clift Dec 14 '18 at 09:32
@ChristhoferNatalius Hmm, it still isn't working. Now I am getting the following as output of my `$formatted_date` : Array ( [0] => 1970-01-01 [1] => 1970-01-01 [2] => 1970-01-01 ) – Paul Clift Dec 14 '18 at 09:43
I guess that this means that my original date is not in a format that `strtotime` can recognise, by why can't it!? – Paul Clift Dec 14 '18 at 09:47
1

Please add in your forloop. $formatted_date[] = date('Y-m-d', strtotime($date[$i])); It is working fine. – Revathi Ganesh Dec 14 '18 at 09:53
Fantastic! Thank you! – Paul Clift Dec 14 '18 at 09:54
Oh I didn't see $date is an array. – Christhofer Natalius Dec 15 '18 at 02:14

Convert date format from d M yy to yyyy-mm-dd

0 Answers0