Summary - Date functions

Compute age and durations with EXTRACT and DATEDIFF.

In this group you learned CURRENT_DATE, EXTRACT, INTERVAL, DATEDIFF and DATE_FORMAT. Date math is now easy.

SELECT EXTRACT(YEAR FROM CURRENT_DATE) AS yil;

This query returns the current year.

The expression EXTRACT(YEAR FROM CURRENT_DATE) AS yil is evaluated and returned.

Exercise Summary - Date functions

Select the month of order_date aliased as ay from orders.

Show example solution

SELECT EXTRACT(MONTH FROM order_date) AS ay
FROM orders