Odoo filtering not working as expected

Question

I am executing the following queries:
SELECT * FROM stock_quant WHERE write_date > '2021-06-19 15:12:11' and the Odoo API also *returns *records that have */write_date = '2021-06-19 15:12:11'/*
I have executed the following query and SELECT * FROM stock_quant WHERE write_date* <= *'2021-06-19 15:12:11' and the Odoo API *doesn not return* records that have write_date* = *'2021-06-19 15:12:11'.

I would expect that for the first query the api will return only records that have write_date greater t

Paul YPI · Accepted Answer

I believe it is because the timestamp in the database includes microseconds but when you look at the record are the value has been trunicated to seconds. So when you see a record with time 15:12:11, in the database it is stored as 15:12:11.222222 (for example) and is therefore greater than 15:12:11
You can confirm this is how the values are stored by connecting to the db from the shell and looking at the values in your write_date field.

関連投稿	返信	ビュー
How to import product variants with my own external id when using dynamic creation mode 解決済 odoo	2 8月 25	2842
How to import Bulk Image in Product your local database not any cloud, odoo.sh 解決済 odoo	1 7月 25	1156
Odoo sh - Connect As odoo	1 8月 25	1152
邮箱无法正常使用 odoo	0 5月 25	1580
How to customise the login screen? odoo	2 4月 25	3771

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！