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.

Related Posts	Răspunsuri	Vizualizări
How to import product variants with my own external id when using dynamic creation mode Rezolvat odoo	2 aug. 25	2832
How to import Bulk Image in Product your local database not any cloud, odoo.sh Rezolvat odoo	1 iul. 25	1152
Odoo sh - Connect As odoo	1 aug. 25	1152
邮箱无法正常使用 odoo	0 mai 25	1570
How to customise the login screen? odoo	2 apr. 25	3766

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!