Updated on 2022-08-17 GMT+08:00

Macro Variables

This section describes the macro variables added to RDS for PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open-source edition.

  • SYSDATE: indicates the current system time.
  • SYSTIMESTAMP: indicates the current system timestamp.
  • DBTIMEZONE: indicates the current database time zone.
  • SESSIONTIMEZONE: indicates the current session time zone.
  • ROWNUM: indicates the tuple number in the query results.