A script-enabled browser is required for this page to function properly.

$$DBTIME$$ System Variable

Syntax

$$DBTIME$$

Description

$$DBTIME$$ retrieves the current time from the local database. Use $$DBTIME$$ to designate a default value or range for a text item using the Initial Value or Lowest/Highest Allowed Value properties. The text item must be of the CHAR or TIME data type.

Usage Notes

Use $$DBTIME$$ when connecting to a remote database that may be in a different time zone from the client's time zone.

The display of system variables is governed by the format mask, either a default data type format mask or one you specify. For example, if you want the default HH:MM:SS format, you must specify a TIME data type. (Note that the default format mask depends on the value of NLS_LANG.)

$$DBTIME$$ Restrictions

If you are accessing a non-ORACLE datasource, avoid using $$DBTIME$$. Instead, use a When-Create-Record trigger to select the current time in a datasource-specific manner.

$$DBTIME$$ Examples

Assume that you want the value of a TIME text item, called ORDERTIME, to default to the current database time. When you define the ORDERTIME text item, specify $$DBTIME$$ in the Initial Value property.