Where Date/Time Functions Can Be Used

Use date/time functions, as you would an expression, in the DML operations listed below:

Table 11-1 Where to Use Date/Time Functions

DML Operation	Clause
[BULK]INSERT ^[1]	VALUES
	WHERE
UPDATE or	SET
UPDATE WHERE CURRENT	WHERE
DELETE or	WHERE
DELETE WHERE CURRENT
[BULK]SELECT	Select list ^[2]
	WHERE
DECLARE	Select list ^[2]
	WHERE
^[1]In the case of a [BULK] INSERT, output functions, TO_CHAR and TO_INTEGER, and the ADD_MONTHS function, are limited to use in the select list and the WHERE clause of a Type 2 INSERT. ^[2]Input functions, TO_DATE, TO_TIME, TO_DATETIME, and TO_INTERVAL, are generally not appropriate in a select list.

Technical documentation