EXTRACT function in Oracle

EXTRACT is one of the vital Date/Time functions of Oracle. It is used to extract a value from a date or interval value. The EXTRACT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

Syntax:

EXTRACT (
{ YEAR | MONTH | DAY | HOUR | MINUTE | SECOND }
| { TIMEZONE_HOUR | TIMEZONE_MINUTE }
| { TIMEZONE_REGION | TIMEZONE_ABBR }
FROM { date_value | interval_value } )

Example 1:

EXTRACT (YEAR FROM DATE '2019-06-26')

Output:

2019

Explanation: The Extract function will extract only the year value from the given date.

Example 2:

EXTRACT (MONTH FROM DATE '2019-06-26')

Output:

6

Explanation: The Extract function will extract only the Month value from the given date.

Please follow and like us:
Content Protection by DMCA.com