Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
odoo
1 Odpovědět
1138 Zobrazení
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
Zrušit
Avatar
Paul YPI
Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
How to import product variants with my own external id when using dynamic creation mode Vyřešeno
odoo
Avatar
Avatar
2
srp 25
2842
How to import Bulk Image in Product your local database not any cloud, odoo.sh Vyřešeno
odoo
Avatar
Avatar
1
čvc 25
1156
Odoo sh - Connect As
odoo
Avatar
1
srp 25
1152
邮箱无法正常使用
odoo
Avatar
0
kvě 25
1580
How to customise the login screen?
odoo
Avatar
Avatar
Avatar
2
dub 25
3771