Current_Timestamp Function

Table 138. Current Timestamp Function 

Field

Description

Description

Returns the current system timestamp and current session Time Zone displacement.

Syntax:

Current_Timestamp(fractional_precision)

fractional_precision

An option precision range for the returned timestamp value. The value range is 0 through 6, inclusive. The default is 6.

Properties

Data type: TIMESTAMP WITH TIME ZONE Length: 12 Not nullable

Fields

YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TIMEZONE_HOUR, TIMEZONE_MINUTE