Reserved Keywords

A list of reserved keywords that cannot be used in user-defined fields.

The following keywords cannot be used as column names of data models.
Reserved keywords
MONTH DAY YEAR HOUR
MIN SEC LENGTH SUBSTR
SUM AVG USE SUBSTRING
MID LOWER UPPER TRIM
SUBSTITUTE LEFT RIGHT FIND
CONCATENATE POSITION SECONDS MINUTES
HOURS DAYS WEEKS MONTHS
YEARS IIF TOTIMESTAMP TOIP
TOSTRING TOINT TOLONG TOFLOAT
TOBOOL EXTRACTJSON EXTRACTKVP TOTIMESTAMPSTRING
INT LONG BOOLEAN DATE
TIME STRING HEX CASE
EXPRESSION
Reserved keywords from the H2 database
ALL CHECK CONSTRAINT CROSS
CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP DISTINCT
EXCEPT EXISTS FALSE FETCH
FOR FOREIGN FROM FULL
GROUP HAVING INNER INTERSECT
IS JOIN LIKE NULL
LIMIT MINUS NATURAL NOT
OFFSET ON ORDER PRIMARY
ROWNUM SELECT SYSDATE SYSTIME
SYSTIMESTAMP TODAY TRUE UNION
UNIQUE WHERE WITH