CakePhp 4.0.1 Postgres timestamp without timezone

Need Help
1

I use Postgres.
Users.created is timestamp without timezone
When i have Users.created in the query, i receive this error:
DateTimeImmutable::__construct(): Failed to parse time string (19/03/2015 22:37:48) at position 0 (1): Unexpected character

2

You can check on following link you got something helpful
https://github.com/cakephp/cakephp/issues/13646

3

You need to change the format of the timestamp string to something DateTime supports.

4

The format in the Users.created field is the “normal” 2015-03-19 22:37:48

5

Your error message indicates that it’s got a string like “19/03/2015 22:37:48”, though.

6

Yes, but i don’t know, why in the error message i have 19/03/2015 22:37:48
My App.defaultLocale = ‘en_US’
App.defaultTimezone = ‘UTC’
Datasources.default.‘timezone’ = ‘UTC’
in /config/app_local.php all the settings are the default recomended settings

The error looks to be in
ROOT/vendor/cakephp/chronos/src/Chronos.php:99

7

I assume your database is doing this. What does running the query return?

You don’t show us anything other than the error.

8

If i don’t have in the query the field Users.created, everithing goes fine.
If i have in the query the field Users.created, in stops on the error that i show you.

9

Well, I have also used that PostgreSQL -
Created - use timestamp with time zone it’s works for me.

10

can you please help me, i write more details on

11

can you please help me, i write more details here