SYS_TIMESTAMP_PHYSICAL

Use the SYS_TIMESTAMP_PHYSICAL script function to retrieve the current date and time in YYYY-MM-DD HH:MM:SS format. You can optionally specify a time zone.

Syntax

SYS_TIMESTAMP_PHYSICAL ([Time Zone|UTC])

Parameters

Parameter Description Format Allowed Values Default Value
Time Zone or UTC
(Optional)		 Specifies the time zone for the date. script literal or script variable
  • Name of a Time Zone object.
    For more information, see Time Zone (TZ).
  • UTC — Returns the time in UTC (Coordinated Universal Time)
 UTC

Examples

The following example determines the current date and time in Sydney. The script function uses a Time Zone object called TZ.SYD which is configured for Australian Eastern Standard Time. The retrieved timestamp is printed in the activation report.

: SET &NOW# = SYS_TIMESTAMP_PHYSICAL ("TZ.SYD" )

: PRINT &NOW#

See also:

seealso

Script Elements for System Conditions and Settings