This function indicates the current date.

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

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 an update value or an insertion value for a column in the date data type or CHAR(10)
   If this function is specified as an update or insertion value for a column in CHAR(10), the current date is converted into a predefined character string representation, and then it is used for updating or insertion.
   
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.