在PHP中将api返回日期时间字符串从24格式转换为12小时格式

Question

I have a datetime like below

17/05/2018 23:59:00 PM

It is storing in database like varchar(100). I want to convert this as 17/05/2018 11:59:00 PM. It is returning from the api.I have tried to fix tried so many ways. somehow it is working but coming tomorrow date like it is giving now like this

18/05/2018 11:59 AM

.Is any efficient way to do this.

 $startdate='17/05/2018 23:59:00 PM';
$myDateTime = DateTime::createFromFormat('d/m/Y H:i A',$startdate);
$newDateString = $myDateTime->format('d/m/Y h:i A');
echo $newDateString;

Answer 1

You are using AM/PM and 24 hour format. That doesn't make sense. PHP is probably trying its best to make sense of it and adding 12 hours to the datetime pushing it to the next day.

If you ignore the PM from your datetime this works just fine:

$startdate='17/05/2018 23:59:00 PM';
$myDateTime = DateTime::createFromFormat('d/m/Y H:i:s+',$startdate);
$newDateString = $myDateTime->format('d/m/Y h:i:s A');
echo $newDateString;

Demo