Configurable date format

[kirill533]

OData clients/servers deliver date differently. For example, https://services.odata.org/OData/OData.svc/Products deivers field "updated" like this: <updated>2020-05-07T12:41:26Z</updated> .

In case of Power BI, it works if the format of the date will be done the following way:

JsonWriter::writeValue

                $dateTime = new \DateTime($value, new \DateTimeZone('UTC'));
                $formattedDateTime = $dateTime->format('Y-m-d\TH:i:s');
                $this->writeCore($formattedDateTime, /* quotes */ true);

Current implementation in master is:

                $dateTime          = new \DateTime($value, new \DateTimeZone('UTC'));
                $formattedDateTime = $dateTime->format('U')*1000;
                $this->writeCore('/Date(' . $formattedDateTime . ')/', /* quotes */ true);

Could you please make it configurable?

[c-harris]

I would be happy to make it configurable (Now that we fixed the config) probably defaulting to the ABNF

dateTimeBody = year "-" month "-" day "T" hour ":" minute [ ":" second [ "." nanoSeconds ] ] year = 4*DIGIT; month = zeroToTwelve day = zeroToThirtyOne hour = zeroToTwentyFour minute = zeroToSixty second = zeroToSixty nanoSeconds = 1*7DIGIT

But i will probably also be kicking it down the road to after we finish #243

[kirill533]

Sure, I was also thinking about that new configurator. This is not a high prio item, just a small item to come closer to the merge of our repos.

[c-harris]

Just tack then on as you come across them and we will do what I can.