Gilles Darold
Gilles Darold
Please @okbob can you recall me how to execute the regression tests?
Ok, maybe I have made another typo too as I have tried make installcheck without success. Running now.
PR pushed. There is still a difference with Oracle. PostgreSQL adds BC to the date returned; ``` =# SELECT oracle.to_date('115032', 'j'); to_date ------------------------ 4398-12-10 00:00:00 BC (1 row) ``` where...
Hi Pavel, I will send another PR to remove the BC part, actually we need the exact same output as Oracle, especially when the date is used as a string...
No other changes for the moment.
Hum, @okbob I'm very sorry but all this patch is just a piece of ..., something is wrong in my understanding of the Oracle way to calculate the Julian Day....
After some more investigations, for some reason that I can not explain, Oracle returns the same date than PostgreSQL if the date is greater or equal to `0200-03-01 00:00:00` but...
This doesn't explain why with two different date as JD referential for to_char(integer, 'J') we have the same result after this date. As I don't want to become crazy I...
Ok, I will still look deeper into that.