1.4.3 CURRENT_TIME value function

Organization of this subsection
(1) Function
(2) Format
(3) Rules

(1) Function

This function indicates the current time.

(2) Format

CURRENT_TIME value-function::= {CURRENT_TIME|CURRENT TIME}

(3) Rules

  1. If the CURRENT_TIME value function is specified, HiRDB interprets that the time data type (TIME) has been specified.
  2. CURRENT_TIME represents the current time. The CURRENT_TIME function can be specified in the following items:
    • In a selection expression or a condition expression
    • As an update or insertion value for a column in the time data type and CHAR(8)
    When the CURRENT_TIME function is specified as an update or insertion value for a column in CHAR(8), the current time is converted into a predefined character string representation, and then it is used for updating or insertion.
  3. Specifying CURRENT_TIME multiple times in an SQL statement produces the same value. Specifying CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP in combination in an SQL statement produces datetime values representing the same point in time.