SQL DAY() Function

SQL DAY() Syntax

The below syntax is used to get day value portion from a given input date value using DAY() function.

For SQL SERVER / MY SQL / MS ACCESS

SELECT DAY('valid_date_value');

The below syntax is used to get day of the month (a integer number from 1 to 31) value from a given table date or datetime column using DAY() function.

For MS ACCESS / SQL SERVER / MY SQL

SELECT DAY(date_column_name1) FROM table_name;

SQL DAY() Example - Using Expression Or Formula

The following SQL SELECT statement will extract the day of the month value from a given input date value. We use now() function to get the input date value.

SELECT 
NOW() AS 'Current Date and Time', 
DAY(NOW()) AS 'Day Value';

The result of above query is:

Sample Database Table - BookOrder

SQL DAY() Example - With Table Column

The following SQL SELECT statement display the column "OrderDate" and "DeliveryDate", from the "BookOrder" table. The DAY() function will extract the day of the month value(a whole integer number from 1 to 31) from the column "OrderDate" and we will stored that value to a new column called "Order Day" and "Delivery Day".

SELECT 
OrderDate, DAY(OrderDate) As 'Order Day', 
DeliveryDate, DAY(DeliveryDate) As 'Delivery Day' 
FROM BookOrder;

The result of above query is: