Cannot convert a date like yyyymmddThhmmss0+0000

Question

I am getting data from a webservice but they send date with this format "yyyymmddThhmmss0+0000" and when i try to create a new DateTime from this format i get this error "DateTime::__construct(): Failed to parse time string ..."

example: "20161122T1030090+0000"

Does anyone have a idea of what kind of format is that, and how to instanciate a dateTime from it ?

Thank you.

Hi @mickmackusa, i have a function that convert dates to a common format (Zulu). but in this case i get an error due to the extra "0" — web hobbit, Apr 19 '18 at 13:13
My point was, you did not offer a complete question. Please edit your question to comply with StackOverflow question requirements. — mickmackusa, Apr 19 '18 at 13:24
How much specificity do you need in your desired output? Can you just truncate what is not needed? — mickmackusa, Apr 19 '18 at 13:30
This might be worth a read: https://stackoverflow.com/q/33691428/2943403 — mickmackusa, Apr 19 '18 at 13:31

score 4 · Accepted Answer · answered Apr 19 '18 at 12:04

4

You can use DateTime::createFromFormat(), with escaping the '\T' and extra 0:

$dt = DateTime::createFromFormat('Ymd\THis\0T','20161122T1030090+0000');
echo $dt->format("Y-m-d H:i:s") ;

Outputs:

2016-11-22 10:30:09

answered Apr 19 '18 at 12:04

Syscall

19,327
10
37
52

thank you @syscall, but is there another way without adding an extra 0 ? and is that a correct date format ? – web hobbit Apr 19 '18 at 13:10
1

@webhobbit Yes, use the format `Ymd\THisuT`, where `u` is the microseconds. It's probably that. – Syscall Apr 19 '18 at 13:16
Yes @Syscall, it could be, and also it could be the "Leap" 1 if it is a leap year, 0 otherwise :D – web hobbit Apr 19 '18 at 13:22
1

Yes @webhobbit Maybe mentionned in the webservice documentation? – Syscall Apr 19 '18 at 13:25
Unfortunately no, but i have a meeting with them in one hour :) , thank you very much @Syscall (y) – web hobbit Apr 19 '18 at 13:32

score -1 · Answer 2 · answered Apr 19 '18 at 12:08

-1

It is UTC format, you should convert it to mm/dd/yyyy HH:MM:SS Format

answered Apr 19 '18 at 12:08

Naveen

25
3

Cannot convert a date like yyyymmddThhmmss0+0000

2 Answers2