MySQLDate/Time FunctionsDAY
MONTH

DAYDate/Time Functions

HOUR

Returns the day.

Syntax

DAY(date)

Example

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;