Reputation: 400
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;
Upvotes: 0
Views: 216
Reputation: 219924
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;
Upvotes: 1
Reputation: 148
I would save the timestamp to the dB rather than the actual date
$startDateTime = DateTime::createFromFormat('d/m/Y H:i:s', '17/05/2018 23:59:00');
$timeStamp = $startDateTime->getTimeStamp();
$date = new DateTime();
$date->setTimestamp($timeStamp);
echo $date->format('d/m/Y h:i:s A');
Upvotes: 0