Extract Year and Month from Date
Easy
date-functions
Amazon
DoorDash
Robinhood
Write a query to extract the year and month from each order's date. Return order_id, order_date, order_year, and order_month, ordered by order_date.
Expected Output: Orders with extracted year and month components.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...