Updated on 2023-07-06 GMT+08:00

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.