DAY() Function in SQL Server

Last Updated : 18 Jan, 2021

DAY() function :
This function in SQL Server is used to return the day of the month i.e, from 1st to 31st for date stated.

Features :

This function is used to find the day of the month for a date specified.
This function comes under Date Functions.
This function accepts only one parameter i.e, date.
This function can also include time with the stated date.

Syntax :

DAY(date)

Parameter :
This method accepts only one parameter as given below as follows.

date –Specified date from which the day of the month is to be returned.

Returns :
It returns the day of the month i.e, from 1st to 31st for a date specified.

Example-1 :
Using DAY() function and getting the day of the month from the date specified.

SELECT DAY('2020/01/02');

Output :

Example-2 :
Using DAY() function with a variable and getting the day of the month from the date specified.

DECLARE @date VARCHAR(50);  SET @date = '2020/01/05';  SELECT DAY(@date);

Output :

Example-3 :
Using DAY() function with date as parameter which includes time as well.

SELECT DAY('2018/11/22 07:44');

Output :

Example-4 :
Using DAY() function with a variable and a date as parameter which includes time as well.

DECLARE @date VARCHAR(50);  SET @date = '2020/11/30 23:59';  SELECT DAY(@date);

Output :

Application :
This function is used to find the day of the month from the date specified.

DATENAME() Function in SQL Server

nidhi1352singh

Improve

Article Tags :

Similar Reads

ATN2() Function in SQL Server

In this article, we are going to cover the ATN2()function in which we will see how we can get the arc tangent of two given numbers. Let's discuss one by one. // here val1 and val2 are input. Input : ATN2(val1, val2) Output : Arc tangent result. ATN2() : It is the function that returns the arc tangen

1 min read

DATEADD() Function in SQL Server

DATEADD() function : This function in SQL Server is used to sum up a time or a date interval to a specified date, then returns the modified date. Features : This function is used to sum up a time or a date interval to a date specified. This function comes under Date Functions. This function accepts

3 min read

DATENAME() Function in SQL Server

DATENAME() function : This function in SQL Server is used to find a given part of the specified date. Moreover, it returns the output value as a string. Features : This function is used to find a given part of the specified date.This function comes under Date Functions.This function accepts two para

2 min read

DATEPART() Function in SQL Server

DATEPART() function :This function in SQL Server is used to find a given part of the specified date. Moreover, it returns the output value as an integer.Features : This function is used to find a given part of the specified date.This function comes under Date Functions.This function accepts two para

2 min read

LOG() Function in SQL Server

The LOG() function returns the logarithm of a specified number or the logarithm of the number to the specified base. Syntax : LOG(number, base) Parameter : LOG() function accepts two-parameters as mentioned above and described below. number - This parameter hold a number which is greater than 0. bas

1 min read

COUNT() Function in SQL Server

The COUNT() function in SQL Server is a fundamental aggregate function used to determine the number of rows that match a specific condition. Counting rows provides valuable insights into data sets such as the total number of records, distinct values, or records meeting certain criteria. In this arti

3 min read

SUM() Function in SQL Server

The SUM() function in SQL Server is an essential aggregate function used to calculate the total sum of values in a numeric column. It aggregates data by summing up all values in the specified column for the rows that match the criteria of the query. In this article, We will learn about SUM() Functio

3 min read

IIF() Function in SQL Server

IIF() function judges or evaluates the first parameter and returns the second parameter if the first parameter is true, otherwise, it returns the third parameter. IIF() function used in SQL Server to add if-else logic to queries.IIF is not supported in dedicated SQL pools in Azure Synapse Analytics.

2 min read

SQL Server ISNULL() Function

The ISNULL() function in SQL Server is a powerful tool for handling NULL values in our database queries. It allows us to replace NULL values with a specified replacement value, ensuring that your queries return meaningful results even when data is missing. In this article, We will learn about the SQ

4 min read

STR() Function in SQL Server

The STR() function converts a numeric value to a character value. Syntax : STR(float_expression [, length [, decimal]]) Parameter : This method accepts three parameters as mentioned above and described below : float_expression : It is a numeric expression that evaluates to an approximate number with

1 min read