Cake 4 Date time format in the data array (SOLVED)

Need Help
1

Good day!

in MySQL table workers field dateof with type datetime.
after the query after toArray() this field as:

[
   'worker' => [
       'name' => 'Alex is Worker',
       'dateof' => '2020-04-28T09:27:00+05:00'
   ]
]

This transform to JSON, but

2020-04-28T09:27:00+05:00 – What is the format??
I need a 2020-04-28 14:27:00

How setup this?

2

I’m solved with

use Cake\I18n\FrozenTime;
use Cake\I18n\FrozenDate;
use Cake\I18n\Date;
use Cake\I18n\Time;

Time::setJsonEncodeFormat('yyyy-MM-dd HH:mm:ss');  // For any mutable DateTime
FrozenTime::setJsonEncodeFormat('yyyy-MM-dd HH:mm:ss');  // For any immutable DateTime
Date::setJsonEncodeFormat('yyyy-MM-dd HH:mm:ss');  // For any mutable Date
FrozenDate::setJsonEncodeFormat('yyyy-MM-dd HH:mm:ss');  // For any immutable Date
3

For the record, the format you were originally getting is a standard form that includes the time zone information, so it eliminates any ambiguity about that. Most APIs will be looking for that format.