Convert SYSDATE and SYSTIMESTAMP to standard SQL

Proprietary

Replaces Oracle's SYSDATE with LOCALTIMESTAMP and SYSTIMESTAMP with CURRENT_TIMESTAMP, which PostgreSQL and other databases understand. Oracle evaluates these once per statement, whereas PostgreSQL returns the time the current transaction started.

org.openrewrite.sql.ConvertSysdate
mod run . --recipe=org.openrewrite.sql.ConvertSysdate

Install it once from Recipe actions, then run it on every repository under the current directory. New to the Moderne CLI? Set it up.