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