Replace usage of SYSDATE with existing getDate() function
Modify PostgreSQL’s version of getDate() to return statement_timestamp() instead of now()
Code that handle Default value - check the presence of SYSDATE and replace it with getDate()
Hi , it sounds simpler just to implement statement_timestamp() in oracle calling SYSDATE, no need for a new function in postgres.
Hi , alright, will do that instead.
Related to this same ticket, we have a function getDate() in the database (both oracle and postgresql) which is wrong because is returning now() instead of statement_timestamp().
I guess it has been harmless in code because getDate is being converted to statement_timestamp, but if used out of iDempiere it could potentially get different results.
Would be better to fix that postgresql function too to make it consistent with the oracle version.
Hi , since we already have that in db, I will just use that to replace sysdate. Will change the postgresql version to return statement_timestamp instead.