DAYOFYEAR() Function in MySQL

DAYNAME() Function in MySQL

Last Updated : 27 Nov, 2020

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 for a specified date.

Example-1 :
Getting the weekday name for a specified date. “2020-11-24”.

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

Output :

Tuesday

Example-2 :
Getting the weekday name from a specified date “2020-11-22 07:12:23”.

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

Output :

Sunday

Example-3 :
Getting the weekday name for the current system date.

SELECT DAYNAME(CURDATE());

Output :

Tuesday

Application :
This function is used to return the weekday name for a specified date.

DAYOFYEAR() Function in MySQL

K

Kanchan_Ray

Improve

Article Tags :

Similar Reads

DAY() Function in MySQL

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 th

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

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

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

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

ELT() Function in MySQL

In this article, we are going to cover ELT function with examples. In ELT function, number field will state that how many strings will be there. ELT function in MySQL is used to returns the string which is at index number specified in the argument list. In this function there is number field and str

DATEDIFF() Function in MySQL

DATEDIFF() function in MySQL is used to return the number of days between two specified date values. Syntax: DATEDIFF(date1, date2) Parameter: This function accepts two parameters as given below: date1: First specified datedate2: Second specified date Returns : It returns the number of days between