If the CURRENT_DATE value function is specified, HiRDB interprets that the date data type (DATE) has been specified.
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.
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.