Re: Too many SET TimeZone and Application_name queries

2019-10-13 Thread Amarendra Konda
Hi Adrian, Thanks a lot for the response. We are using JDBC Driver 42.2.8 along with the Tomcat Server on Java 8. As part of application code, We are *not* setting timezone (or) application names. One observation was, application was querying columns of the datatype "timestamp without time zone"

Re: day interval

2019-10-13 Thread Adrian Klaver
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

RE: Re: day interval

2019-10-13 Thread Abraham, Danny
Thanks everyone. EDB installs oracle compatible parameters. 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 da