MONTH
DAY
HOUR
Returns the day.
DAY(date)
Enter values below to update the example in real time.
order_id
order_date
order_day
orders
SELECT order_id, DAY(order_date) AS order_day FROM orders;