Search notes:
ORA-30089: missing or invalid datetime field
The first of the following two statements runs ok while the second throws ORA-30089: missing or invalid <datetime field>.
select interval '0 12:34:56' day (4) to second from dual;
select interval '0 12:34:56' days(4) to second from dual;
The following statement throws the same error:
select
interval '0 12:34:56'
from
dual;