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
2019 8:48 PM
To: Abraham, Danny
Cc: Adrian Klaver ; pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
>>>>> "Abraham" == Abraham, Danny writes:
Abraham> Thanks for the clarification.
Abraham> The problem is still this:
Abraham> select dat
Andrew Gierth writes:
> "Abraham" == Abraham, Danny 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.
> "Abraham" == Abraham, Danny writes:
Abraham> Thanks for the clarification.
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 wh
w Gierth
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
On 10/12/19 8:37 AM, Abraham, Danny wrote:
Thanks Andrew.
My code fails since the expression (In a PG/PG SQL function) which
assumes integer result Now produces the string '8 day';
The code is?
This has
aturday, October 12, 2019 7:53 PM
To: Abraham, Danny
Cc: Adrian Klaver ; pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
>>>>> "Abraham" == Abraham, Danny writes:
Abraham> The problematic code is:
Abraham> select date(cm_curr_date) - date(CM_DATE)
> "Abraham" == Abraham, Danny writes:
Abraham> The problematic code is:
Abraham> select date(cm_curr_date) - date(CM_DATE) into diff_days from
CMS_SYSPRM;
This will always return an integer, unless either the date() cast or the
-(date,date) operator have been redefined or modified.
Abra
ng lc_time, timezone and datestyle .. but nothing seems to work
Thanks
Danny
-Original Message-
From: Adrian Klaver
Sent: Saturday, October 12, 2019 7:27 PM
To: Abraham, Danny ; Andrew Gierth
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
On 10/12/19 8:37 A
B PG 9.6.3.
I know the fix, but I need the ability to create the bug in my server, and I do
not know how.
Thanks
Danny
-Original Message-
From: Andrew Gierth
Sent: Saturday, October 12, 2019 6:26 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: da
---
From: Andrew Gierth
Sent: Saturday, October 12, 2019 6:26 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
"Abraham" == Abraham, Danny writes:
Abraham> Hi
Abraham> A question on day interval
Abraham> select date('20191001')
the bug in my server, and I do
not know how.
Thanks
Danny
-Original Message-
From: Andrew Gierth
Sent: Saturday, October 12, 2019 6:26 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
>>>>> "Abraham" == Abraham, Danny
>>>>> "Abraham" == Abraham, Danny writes:
Abraham> Hi
Abraham> A question on day interval
Abraham> select date('20191001') - date('20190923');
Abraham> Will provide sometimes '8' - an integer , but sometimes '8
Abr
Hi
A question on day interval
select date('20191001') - date('20190923');
Will provide sometimes '8' - an integer , but sometimes '8 day' - a string
How can I control it to return integer always?
Thanks
Danny
13 matches
Mail list logo