y-d-m date format convert in php

karthika pommudu

6y1.6kPHP

Here the code,

$date = '03/17/2020 - 04/15/2020';

$pieces = explode("-", $date);

$date11= $pieces[0]; // piece1

$date12= $pieces[1]; // piece2

$date1 = str_replace('/', '-', $date11);

$DATE1 = date('Y-d-m', strtotime($date1));

$date2 = str_replace('/', '-', $date12);

$DATE2= date("Y-m-d", strtotime(preg_replace('/[^A-Za-z0-9\-]/', '',$date2)));

echo $DATE1; //2020-03-17

echo $DATE2;//1970-01-01

Output: $DATE1 : 2020-03-17

$DATE2: 1970-01-01

Please advice.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Siddharth Gajbhiye6y ago
Accepted answer
Hello karthika pommudu

I found the error in your code actually you are setting date in wrong format it should be date/month/year and you are taking month/date/year
see i have update your code which i have used a correct format of date and now its giving me correct output
$date = '17/03/2020 - 15/04/2020';

$pieces = explode("-", $date);
$date11= $pieces[0]; // piece1
$date12= $pieces[1]; // piece2

$date1 = str_replace('/', '-', $date11);
$DATE1 = date('Y-d-m', strtotime($date1));

$date2 = str_replace('/', '-', $date12);
$DATE2= date("Y-m-d", strtotime(preg_replace('/[^A-Za-z0-9-]/', '',$date2)));
echo $DATE1; //2020-03-17
echo $DATE2;//1970-01-01
Check its output  2020-17-032020-04-15
Thank you
karthika pommudu6y ago
Hi siddharth,

Thanks for your great help to clear this.

Stay with safe.
Siddharth Gajbhiye6y ago
The strtotime() function parses an English textual datetime into a Unix timestamp (the number of seconds since January 1 1970 00:00:00 GMT).

Note: If the year is specified in a two-digit format, values between 0-69 are mapped to 2000-2069 and values between 70-100 are mapped to 1970-2000.

Note: Be aware of dates in the m/d/y or d-m-y formats; if the separator is a slash (/), then the American m/d/y is assumed. If the separator is a dash (-) or a dot (.), then the European d-m-y format is assumed. To avoid potential errors, you should YYYY-MM-DD dates or date_create_from_format() when possible.
Siddharth Gajbhiye6y ago
ok
karthika

let me check for this one
karthika pommudu6y ago
Hi Siddharth,

Thanks for your reply.

Yup, exactly what I want is '03/17/2020 - 04/15/2020'.

But when I use the above mentioned code to convert the format, its will comeout like '03/17/2020 -1970-01-01'.
Siddharth Gajbhiye6y ago
Hello

One more example with your code
$date = '03/17/2020 - 04/15/2020';

$pieces = explode("-", $date);
$date11= $pieces[0]; // piece1
$date12= $pieces[1]; // piece2

$date1 = str_replace('/', '-', $date11);
$DATE1 = date('Y-d-m', strtotime($date1));


echo nl2br("Your Code");
echo $DATE1;
echo $date1;
echo nl2br("n");
echo nl2br("My Code");
$originalDate = "2010-03-21";
$newDate = date("Y-d-m", strtotime($originalDate));
echo $newDate;
Output:
Your Code1970-01-0103-17-2020
My Code2010-21-03
Siddharth Gajbhiye6y ago
Hello Kartika
$date=date_create("2013-03-15");
echo date_format($date,"Y-d-m H:i:s");
?>
Output : 2013-15-03 00:00:00

Just like the format you want

Thank you