date/time field value out of range: "32-12-01" HINT: Perhaps you need a different "datestyle" setting.

Question

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

Niyas Raphy (Walnut Software Solutions) · 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

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi
Try using the query,
*SET datestyle = dmy;*please refer this: https://stackoverflow.com/posts/29383758/edit [1]
Hope it helps

[1] https://stackoverflow.com/posts/29383758/edit

相關帖文	回覆	瀏覽次數
[15.0] AttributeError: 'NoneType' object has no attribute 'envs' when create new database 已解決 postgresql v15 AttributeError	1 2月 22	4094
AttributeError: module 'werkzeug.routing' has no attribute 'NumberConverter' postgresql nginx werkzeug v15	3 7月 25	8558
Prevent navigation if records are not save v15	1 6月 25	1770
Sales order line comment to Purchase order line comment 已解決 v15	3 7月 25	3376
attribute is not applied when dynamically rendering v15	1 5月 25	1526

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！