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
Thanks for the clarification.
The problem is still this:
select date('20191001') - date('20190101') ;
in my servers it is always '273'.
In the customer's DB it is '273 days';
Thanks
Danny
-Original Message-
From: Andrew Gierth
Sent: Saturday, October 12, 2019 7:53 PM
To: Abraham, Dann
The problematic code is:
select date(cm_curr_date) - date(CM_DATE) into diff_days from CMS_SYSPRM;
The fix is:
select date_part ('day', age( date(cm_curr_date), date(CM_DATE))) into
diff_days from CMS_SYSPRM;
The problem:
How to recreate the problem. (You know - QA).
Tried changing lc_time, t
Thanks Andrew.
My code fails since the expression (In a PG/PG SQL function) which assumes
integer result
Now produces the string '8 day';
This has been working for years on all PG community servers.
This happens on an EDB PG 9.6.3.
I know the fix, but I need the ability to create the bug in my
