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