Search notes:

ORA-30076: invalid extract field for extract source

The following statement throws ORA-30076: invalid extract field for extract source:

select
   extract(hour from sysdate)
from
   dual;

However, this statement is ok:

select
   extract(day from sysdate)
from
   dual;

This statement is also ok:

select
   extract(hour from systimestamp)
from
   dual;

See also