Convert date format to php

Question

Personal I am working with Wordpress php and get from the database a date in the following format: "22 October, 2018", more need to convert it to "2018-10-22", how do I get that?

tried:

date('Y-m-d', strtotime(get_post_meta( $id_pedido, "Data de entrega", true )));

The value returned is "1970-01-01" and not the date reported. Thank you!

Answer 1

You can use the function substr() of PHP. Ex:

$data = "22 Outubro, 2018";

$ano = substr($data,-4); //4 dos últimos 4 caracteres e o "-" para começar a contar do final.

$dia = substr($data,0,2; //0 do ponto inicial e 2 para dois caracteres a partir de 0.

$mes_array = explode(" ", $data);//Separa nos espaços a string "data" e transforma em um array.
$mes = $mes_array[1];//Seleciona o a segunda posição do array.

Answer 2

You can assemble something simpler than suggested in the link. The first step is to define two arrays one for search and one for substitution (from Portuguese to English) because the names of the months or days of the week cannot be converted into a valid date if specified in Portuguese. Note that the first element of $en is a glass that will be replaced by nothing.

After cleaning (replaced with str_ireplace()) the string just call the method createFromFormat() of DateTIme defined the input format that in the case is the day (d) following the month in full (F) and last the four-digit year (Y).

format() sets the format you want Y-m-d.

$pt = [',', 'janeiro', 'fevereiro', 'março', 'abril', 'maio', 'junho', 'julho', 'agosto', 'setembro', 'outubro', 'novembro', 'dezembro']; 
$en = ['', 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'];

$data = DateTime::createFromFormat('d F Y', str_ireplace($pt, $en,'22 maio, 2018'));
echo $data->format('Y-m-d');

Example - ideone

Answer 3

Personal thanks to all I managed to settle as follows:

$data_de_entrega = get_post_meta( $id_pedido, "Data de entrega", true );
$pt = [',', 'Janeiro', 'Fevereiro', 'Março', 'Abril', 'Maio', 'Junho', 'Julho', 'Agosto', 'Setembro', 'Outubro', 'Novembro', 'Dezembro']; 
$en = ['','January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'];
$data_new = str_replace($pt, $en, $data_de_entrega);

echo date('Y-m-d', strtotime($data_new));

Answer 4

Try to do that:

$tempo = strtotime("22 October 2018");
echo date("Y-m-d", $tempo);

Remembering that the function expects to be informed a string containing a date format in English US, in this case, "22 October 2018".

Note: This is also for all other months, that is, you should add the month written in English.

For more information: http://php.net/manual/en/function.strtotime.php