Oracle ORA_DST_ERROR() Function

Oracle ORA_DST_ERROR() is a built-in function that returns a number indicating whether the given date-time value would cause errors with the new time zone data.

This function can only be executed when changing the time zone data file of the database and upgrading the time zone data timestamp, and only between the execution of the DBMS_DST.BEGIN_PREPARE and DBMS_DST.END_PREPARE programs or between the execution of the DBMS_DST.BEGIN_UPGRADE and DBMS_DST.END_UPGRADE programs.

Oracle ORA_DST_ERROR() Syntax

Here is the syntax of the Oracle ORA_DST_ERROR() function:

ORA_DST_ERROR(datetime_expr)

Parameters

datetime_expr

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

Return Value

The Oracle ORA_DST_ERROR() function returns a number indicating whether the given date-time value would cause errors with the new time zone data. Here are all the return values of this function:

  • 0: The given date-time value would not cause errors with the new time zone data.
  • 1878: The given date-time value would cause an “unrecognized time” error.
  • 1883: The given date-time value would cause a “repeated time” error.

Conclusion

Oracle ORA_DST_ERROR() is a built-in function that returns a number indicating whether the given date-time value would cause errors with the new time zone data.