Stepwise-Lab

ORA-30076: Invalid extract field for extract source

EXTRACT can take only YEAR, MONTH and DAY from a DATE; HOUR, MINUTE and SECOND need a TIMESTAMP.

On the exam

This error belongs to the topic Time zones and intervals of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors