Skip to Content
Dette spørgsmål er blevet anmeldt
postgresqlv15
2 Besvarelser
5478 Visninger
Avatar
Shakuur ally 
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
Kassér
Avatar
Niyas Raphy (Walnut Software Solutions)
Bedste svar

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
Kassér
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Bedste svar

Hi

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

Hope it helps

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
[15.0] AttributeError: 'NoneType' object has no attribute 'envs' when create new database Løst
postgresql v15 AttributeError
Avatar
Avatar
1
feb. 22
4065
AttributeError: module 'werkzeug.routing' has no attribute 'NumberConverter'
postgresql nginx werkzeug v15
Avatar
Avatar
Avatar
Avatar
3
jul. 25
8489
Prevent navigation if records are not save
v15
Avatar
Avatar
1
jun. 25
1702
Sales order line comment to Purchase order line comment Løst
v15
Avatar
Avatar
3
jul. 25
3330
attribute is not applied when dynamically rendering
v15
Avatar
1
maj 25
1470