Help Center> Relational Database Service> User Guide> Working with RDS for PostgreSQL> PostgreSQL Enhanced Edition> Macro Variables
View PDF

Macro Variables

This section describes the marco variables added to 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.