Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
odoo
1 Odgovori
1125 Prikazi
Avatar
Nova Nover

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 than '2021-06-19 15:12:11'. And in the second query I expect to get records that have write_date less then or equal to '2021-06-19 15:12:11', but this does not happen.

Could you please let me know why there is such a behaviour? 



Avatar
Opusti
Avatar
Paul YPI
Best 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.

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
How to import product variants with my own external id when using dynamic creation mode Solved
odoo
Avatar
Avatar
2
avg. 25
2833
How to import Bulk Image in Product your local database not any cloud, odoo.sh Solved
odoo
Avatar
Avatar
1
jul. 25
1152
Odoo sh - Connect As
odoo
Avatar
1
avg. 25
1152
邮箱无法正常使用
odoo
Avatar
0
maj 25
1573
How to customise the login screen?
odoo
Avatar
Avatar
Avatar
2
apr. 25
3766