date conversion issue

Hello all!

Can anyone tell me why an SQL datetime stored as 2015-05-02 13:02:03 goes through the following expression:


and then comes out as the wrong time: 2015-05-02T01:05:03Z

By the way: I have to use the Y-m-d\Th:m:s\Z format for a widget that needs it in that format


This comes down to some advice from this page:

The author seems to advise that we use that format ‘Y-m-d\Th:m:s\Z’

But in my case I used ‘Y-m-d H:i:s’ and got correct results.

Go figure. :)