Replace SYSDATE with getDate()

Description

  1. Replace usage of SYSDATE with existing getDate() function

  2. Modify PostgreSQL’s version of getDate() to return statement_timestamp() instead of now()

  3. Code that handle Default value - check the presence of SYSDATE and replace it with getDate()

 

 

Environment

None

Assignee

Heng Sin Low

Reporter

Heng Sin Low

Labels

None

Tested By

None

Components

Fix versions

Priority

Major
Configure