EXTRACT

Pull year, month, day out of a date.

With EXTRACT you pull a part like year, month or day from a date. You use YEAR, MONTH, DAY.

SELECT EXTRACT(YEAR FROM order_date) AS yil FROM orders;

This query returns the year of each order.

EXTRACT(YEAR FROM order_date) AS yil is selected from orders.

EXTRACT — details

Some databases offer a YEAR(date) function. EXTRACT is ANSI standard and works across all major databases.

Select the year of order_date aliased as yil from orders.

Show example solution

SELECT EXTRACT(YEAR FROM order_date) AS yil
FROM orders

Extract year

SELECT ____(YEAR FROM order_date) FROM orders;

Show answer

SELECT EXTRACT(YEAR FROM order_date) FROM orders;