After more browsing in the Strapi github issues, I think this problem related to PostgreSQL datestyle which you can set with SQL query SET datestyle TO 'ISO, MDY'.
Based on this github issue When postgres datestyle is set to SQL, DMY all created_at and updated_at dates are returning null · Issue #6783 · strapi/strapi · GitHub, Strapi currently don’t support ISO, DMY datestyle