EXTRACT

version 11

EXTRACT ({YEAR | MONTH | DAY | HOUR | MINUTE | SECOND | MILLISECOND} FROM arithmetic_expression)

The EXTRACT function returns the specified part which it extracts from the arithmetic_expression. The arithmetic_expression passed should be of the Timestamp type.

This example returns all the invoice numbers from the month of January:

   SELECT INVOICE_NO
     FROM INVOICES
    WHERE EXTRACT(MONTH(INVOICE_DATE)) = 1;