When postgres datestyle is set to SQL, DMY all created_at and updated_at dates are returning null

[MSLacerda]

Describe the bug

Using postgres datestyle config set to SQL, DMY all dates used in strapi are returned as null in api and admin-ui.

Steps to reproduce the behavior

1. Set postgres datestyle to SQL, DMY
2. Create new project on strapi
3. Create a content type and add a entry
4. Make a api request or in collection table in admin visualize the created_at column

Expected behavior

The date fields must return values, actually the attributes created_at and updated_at are returning only null values.

Screenshots

In database:

System

• Node.js version: v12.18.0
• NPM version: 6.14.4
• Strapi version: 3.0.4
• Database: Postgres
• Operating system: Linux Mint and strapi/base docker image

[lauriejim]

Hello!
Why do you want to change the data format that manages Strapi?
I'm closing this issue, Strapi will not be able to manage another format, so please keep the default one.
Thank you and have a good day.

[derrickmehaffy]

You will want to review the following guide: https://strapi.io/documentation/v3.x/guides/custom-data-response.html

And you can use something like moment.js to dynamically convert them, (which Strapi uses to convert in the backend on save/fetch anyway)

[strapi-bot]

This issue has been mentioned on Strapi Community Forum. There might be relevant details there:

https://forum.strapi.io/t/in-strapi-while-reading-data-from-postgres-db-getting-all-dates-as-null-in-response/28611/4