DATALENGTH() Function in SQL Server

DAY() Function in MySQL

Last Updated : 02 Dec, 2020

DAY() function :
This function in MySQL is used to return the day of the month for a specified date (a number from 1 to 31). This function equals the DAYOFMONTH() function.

Syntax :

DAY(date)

Parameter :
This method accepts a parameter which is illustrated below :

date : Specified date to extract the day from.

Returns :
It returns the day of the month for a specified date (a number from 1 to 31).

Example-1 :
Getting the day of the month from a specified date “2020-11-24”.

SELECT DAY("2020-11-24");

Output :

Example-2 :
Getting the day of the month from a specified date “2020-11-22 07:12:23”.

SELECT DAY("2020-11-22 07:12:23");

Output :

Example-3 :
Getting the day of the month for the current system date.

SELECT DAY(CURDATE());

Output :

Application :
This function is used to return the day of the month for a specified date (a number from 1 to 31).

DATALENGTH() Function in SQL Server

K

Kanchan_Ray

Improve

Article Tags :

Similar Reads

TO DAYS() FUNCTION in MySQL

TO DAYS() : TO DAYS() function in MySQL takes the given date and returns a number of days since year 0 corresponding to the given date.TO DAYS() function can only be used with the dates within the Gregorian calendar. Syntax : TO DAYS(date) Parameters: The function can accept only one argument as sho

DAYNAME() Function in MySQL

DAYNAME() function : This function in MySQL is used to return the weekday name for a specified date. Syntax : DAYNAME(date) Parameter : This method accepts a parameter which is illustrated below as follows. date - Specified date to extract the weekday name from Returns : It returns the weekday name

DIV() Function in MySQL

DIV() function : This function in MySQL is used to return a quotient (integer) value when integer division is done. For example, when 7 is divided by 3, then 2 will be returned. Syntax : SELECT x DIV y; Parameter : This method accepts two parameters as given below as follows. x - Specified dividend

FROM_DAYS() Function in MySQL

FROM_DAYS() : This function is used to return the date from a specified numeric date value. Here specified date value is divided by 365 and accordingly years, months, and days are returned. This function is used only with dates within the Gregorian calendar. Features : This function is used to find

DAYOFYEAR() Function in MySQL

DAYOFYEAR() function: This function in MySQL is used to return the day of the year for a specified date (a number from 1 to 366). Syntax : DAYOFYEAR(date) Parameter : This method accepts a parameter which is illustrated below: date: Specified date to return the day of the year from Returns : It retu

DAYOFWEEK() Function in MySQL

DAYOFWEEK() function : This function in MySQL is used to return the weekday index for a specified date (a number from 1 to 7). Note : 1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday. Syntax : DAYOFWEEK(date) Parameter : This method accepts a parameter which is illustrate

CURDATE() Function in MySQL

The CURDATE() function in MYSQL is used to return the current date. The date is returned to the format of "YYYY-MM-DD" (string) or as YYYYMMDD (numeric). This function equals the CURRENT_DATE() function. In this article, we are going to discuss about CURDATE() function in detail. Syntax CURDATE(); P

DAYOFMONTH() Function in MySQL

DAYOFMONTH() function : This function in MySQL is used to return the day of the month for a specified date (a number from 1 to 31). This function equals the DAY() function. Syntax : DAYOFMONTH(date) Parameter : This method accepts a parameter which is illustrated below as follows. date - Specified d

COT() Function in MySQL

COT() function : This function in MySQL is used to return the cotangent of a specified number. If the specified number is 0, an error or NULL will be returned. In a right triangle, the cotangent of an angle is the length of it's adjacent side divided by the length of the opposite side. Similarly, th

FIELD() function in MySQL

FIELD() : This function helps in returning the position of a value in the given value list. If the user passes string values as the argument of FIELD() function, then the search will be performed as string values. And, If the user passes numeric values as the argument of FIELD() function, then searc