psycopg2.errors.DatetimeFieldOverflow: date/time field value out of range: "32-12-01" LINE 5: date >= '32-12-01' and ^ HINT: Perhaps you need a different "datestyle" setting.
i see this when i try chenerating report, anyone can solve
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
psycopg2.errors.DatetimeFieldOverflow: date/time field value out of range: "32-12-01" LINE 5: date >= '32-12-01' and ^ HINT: Perhaps you need a different "datestyle" setting.
i see this when i try chenerating report, anyone can solve
Hi,
In the shown value of the data, there is a 32, which i believe representing the day and we dont have a month with 32 days. So you have to check and see how you get this value and from the 32 is inputted and adjust the logic to be the day between 0 and 31.
Thanks
Hi
Try using the query,
SET datestyle = dmy;please refer this:https://stackoverflow.com/posts/29383758/edit
Hope it helps
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
RegistrierenVerknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
---|---|---|---|---|
|
1
Feb. 22
|
3958 | ||
|
3
Juli 25
|
8316 | ||
|
1
Juni 25
|
1503 | ||
|
3
Juli 25
|
3195 | ||
|
1
Mai 25
|
1333 |