Level 104
If $this->getDateFormat() returns a format using the lowercaseh for hours, then Carbon is not expecting 24 hour times - you need to use the 24 hour formatter H when parsing the datetime from the database.
Apr 13, 2018
9
Level 1
Carbon::createFromFormat dropping
Hi Everyone, I'm having an issue since 2 days and im researching to find a solution for this. The problem is, I'm reading Mysql timestamps and laravel converting those stamps to carbon instance by default. But when it runs Carbon::createFromFormat($this->getDateFormat(), $value) this function and if the time in timestamp is higher than 12 (e.g 16:00:00) then it drops with error message saying "Failed to parse time string (2017-09-25 16:50 PM) at position 17 (P): The timezone could not be found in the database" ... Any help will be highly appreciated.
Regards
Level 1
yes, its 'Y-m-d H:i:s' so its already 24hrs format
Level 13
Your time string is invalid.
16:50 PM would be 16 hours and 50 minutes after noon.
Level 50
2017-09-25 16:50 PM is not equal to this 'Y-m-d H:i:s'. at position 17 (P) it can't read PM. it expects seconds
Level 104
But your datetime string 2017-09-25 16:50 PM is not in that format - so you are telling it to use a particular format (Y-m-d H:i:s) to parse the string, but then you are not giving a datetime string in the same format. How can this be expected to work?
Level 1
See in tinker i ran same command
- Carbon\Carbon::createFromFormat('Y-m-d G:i:s', '2018-04-04 16:00:00');
- Carbon\Carbon::createFromFormat('Y-m-d H:i:s', '2018-04-04 16:00:00')
same error im getting in both cases....
Level 1
It was the Php version issue with Carbon api.... can not work with php > 7.1.
Level 67
Have you tried updating the carbon package? They've fixed that stuff. http://carbon.nesbot.com/history/
Current laravel 5.6 uses "nesbot/carbon": "^1.24.1",
Level 13
Could you be a little more specific? What version of Carbon are you using and what version of PHP does it not work on?
Please or to participate in this conversation.