Skip to Content
This question has been flagged
postgresqlv15
2 Replies
4523 Views
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
Discard
Avatar
Niyas Raphy (Walnut IT)
Best Answer

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
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi

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

Hope it helps

Avatar
Discard
Related Posts Replies Views Activity
[15.0] AttributeError: 'NoneType' object has no attribute 'envs' when create new database Solved
postgresql v15 AttributeError
Avatar
Avatar
1
Feb 22
3387
attribute is not applied when dynamically rendering
v15
Avatar
1
May 25
144
Prevent navigation if records are not save
v15
Avatar
0
May 25
196
Creating user creates duplicated partner_id
v15
Avatar
1
May 25
564
Odoo Custome Module Language Creation
v15
Avatar
Avatar
Avatar
Avatar
4
May 25
1861