Extracts a specific field from a date/time value.
Syntax
EXTRACT(field FROM source)Example
Enter values below to update the example in real time.
order_date→total_amount→revenue→orders→-- 분기별 매출
SELECT EXTRACT(QUARTER FROM order_date) AS quarter,
SUM(total_amount) AS revenue
FROM orders
GROUP BY quarter;