Andrew Gierth <andrew@xxxxxxxxxxxxxxxxxxxx> writes: > "Abraham" == Abraham, Danny <danny_abraham@xxxxxxx> writes: > Abraham> The problem is still this: > Abraham> select date('20191001') - date('20190101') ; > Abraham> in my servers it is always '273'. > Abraham> In the customer's DB it is '273 days'; > Then you need to establish why that is. I recall having heard that EDB installs some non-PG datetime operators to make things act more similar to Oracle. regards, tom lane