Oracle's interval data types store a period of time. When you want to format an interval as a string, you can use the TO_CHAR function.
A. This statement will not execute successfully because TO_DATE expects a string representing a date, not a number derived from an interval.
B. This statement will not execute successfully because TO_NUMBER does not support interval data types as an input.
C. This statement will not execute successfully because TO_DATE does not support interval data types as an input.
D. This statement will not execute successfully because TO_NUMBER expects a number or a string representing a number as an argument, not a date.
E. This statement will execute successfully. TO_CHAR function can be used to convert interval values to a formatted string, such as 'HH24:MM'.
[Reference:, Oracle Documentation on Datetime Functions: https://docs.oracle.com/database/121/SQLRF/functions092.htm#SQLRF00654, ]
Submit