SYS_TIMESTAMP_PHYSICAL

Use the SYS_TIMESTAMP_PHYSICAL script function to retrieve the current date and time at the moment of processing, 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 (Optional)	Specifies the time zone for the returned timestamp. For more information, see Time Zone (TZ).	Script literal or script variable	Name of a Time Zone object — Returns the timestamp in the specified time zone UTC — Returns the timestamp in Coordinated Universal Time	UTC

Examples

The following example retrieves the current date and time in Sydney using a Time Zone object called TZ.SYD, configured for Australian Eastern Standard Time, and prints the result to the activation report.

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

: PRINT &NOW#