Oracle ORA_DST_AFFECTED() Function

Oracle ORA_DST_AFFECTED() is a built-in function that checks whether the given datetime expression is affected by the modification of the time zone file.

This function can only be run when the database time zone data file is changed and the time zone data upgrade timestamp is updated, and can only be executed between the DBMS_DST.BEGIN_PREPARE and DBMS_DST.END_PREPARE procedures or between the DBMS_DST.BEGIN_UPGRADE and DBMS_DST.END_UPGRADE procedures.

Oracle ORA_DST_AFFECTED() Syntax

Here is the syntax for the Oracle ORA_DST_AFFECTED() function:

ORA_DST_AFFECTED(datetime_expr)

Parameters

datetime_expr

Required. It must parse to a TIMESTAMP WITH TIME ZONE value or a VARRAY object containing a TIMESTAMP WITH TIME ZONE value.

Return Value

The Oracle ORA_DST_AFFECTED() function returns 1 or 0. It returns 1 if the given datetime value is affected by the new time zone data or will result in a “nonexistent time” or “repeated time” error due to the new time zone, and 0 otherwise.

Conclusion

Oracle ORA_DST_AFFECTED() is a built-in function that checks whether the given datetime expression is affected by the modification of the time zone file.