1.5.2 CURRENT_DATE value function

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

(1) Function

This function indicates the current date.

(2) Format

CURRENT_DATE value-function::= {CURRENT_DATE|CURRENT DATE}

(3) Rules

  1. If the CURRENT_DATE value function is specified, HiRDB interprets that the date data type (DATE) has been specified.
  2. CURRENT_DATE represents the current date. The CURRENT_DATE 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 date data type
    • As a value to be updated or inserted into a CHAR(10) column (or into a CHAR(20) column when UTF16 is specified as the character set)
      When CURRENT_DATE is specified as an update or insertion into a CHAR(10) column (or into a CHAR(20) column when UTF16 is specified as the character set), the update or insertion is performed after the current date is converted into the default string representation for dates.
  3. Specifying CURRENT_DATE 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.