1.5.3 CURRENT_TIME value function

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

(1) Function

Represents the current time converted from the localtime function of the OS. The time zone is determined based on the TZ operand of the system common definition.

(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 a value to be updated or inserted into a time data type
    • As a values to be updated or inserted into a CHAR(8) column (or a CHAR(16) column when UTF16 is specified as the character set)
      When CURRENT_TIME is specified as an update or insertion into a CHAR(8) column (or into a CHAR(16) column when UTF16 is specified as the character set), the update or insertion is performed after the current time is converted into the default string representation for times.
  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.