Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
2 Antworten
5576 Ansichten
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


Avatar
Verwerfen
Beste Antwort

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

Avatar
Verwerfen
Beste Antwort

Hi

Try using the query,
      SET datestyle = dmy;please refer this:https://stackoverflow.com/posts/29383758/edit

Hope it helps

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
1
Feb. 22
4155
3
Juli 25
8743
1
Juni 25
1924
3
Juli 25
3515
1
Mai 25
1635