On 10/13/19 12:50 AM, Abraham, Danny wrote:
Thanks everyone.
EDB installs oracle compatible parameters.
To be clear this is for their Postgres Advanced Server, not the one you
would download from here:
https://www.postgresql.org/download/windows/
See below
C:\Program Files\edb\as9.6\bin>psql -p5488 postgres enterprisedb
Password for user enterprisedb:
psql (9.6.2.7)
...
### Oracle compatible mode
postgres=# select date('20191001') - date('20190101');
?column?
----------
273 days
(1 row)
## Postgres compatible mode
postgres=# set edb_redwood_date=off;
SET
postgres=# select date('20191001') - date('20190101');
?column?
----------
273
(1 row)
--
Adrian Klaver
[email protected]
