RDB$TIME_ZONES

Reserved Words and KeywordsMonitoring Tables

`RDB$TIME_ZONES`

RDB$TIME_ZONES lists the named time zones supported by the engine.It is a virtual table that is populated using the current time zone database of the Firebird engine.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$TIME_ZONE_ID`	`INTEGER`	The unique identifier of the time zone as used by Firebird.For example, this identifier is used in the `time_zone` field of the `ISC_TIMESTAMP_TZ` struct if the value has a named zone instead of an offset.
`RDB$TIME_ZONE_NAME`	`CHAR(63)`	Name of the time zone as specified by the time zone database

RDB$TIME_ZONE_ID

INTEGER

The unique identifier of the time zone as used by Firebird.For example, this identifier is used in the time_zone field of the ISC_TIMESTAMP_TZ struct if the value has a named zone instead of an offset.

RDB$TIME_ZONE_NAME

CHAR(63)

Name of the time zone as specified by the time zone database

`RDB$TRANSACTIONS`

RDB$TRANSACTIONS stores the states of distributed transactions and other transactions that were prepared for two-phase commit with an explicit prepare message.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$TRANSACTION_ID`	`INTEGER`	The unique identifier of the transaction being tracked
`RDB$TRANSACTION_STATE`	`SMALLINT`	Transaction state: `0` - in limbo `1` - committed `2` - rolled back
`RDB$TIMESTAMP`	`TIMESTAMP WITH TIME ZONE`	Not used
`RDB$TRANSACTION_DESCRIPTION`	`BLOB`	Describes the prepared transaction and could be a custom message supplied to `isc_prepare_transaction2`, even if it is not a distributed transaction.It may be used when a lost connection cannot be restored

RDB$TRANSACTION_ID

INTEGER

The unique identifier of the transaction being tracked

RDB$TRANSACTION_STATE

SMALLINT

Transaction state:

0 - in limbo
1 - committed
2 - rolled back

RDB$TIMESTAMP

TIMESTAMP WITH TIME ZONE

Not used

RDB$TRANSACTION_DESCRIPTION

BLOB

Describes the prepared transaction and could be a custom message supplied to isc_prepare_transaction2, even if it is not a distributed transaction.It may be used when a lost connection cannot be restored