How to display the day name on the basis of Date of Birth records in MySQL?

Use the DAYNAME() to display the day name from records with Date of Birth.

Let us first create a table −

mysql> create table DemoTable795 (
   DateOfBirth date
);
Query OK, 0 rows affected (0.61 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable795 values('1996-01-21');
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable795 values('2004-11-01');
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable795 values('1990-03-31');
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable795 values('2010-12-03');
Query OK, 1 row affected (0.13 sec)

Display all records from the table using select statement −

mysql> select *from DemoTable795;

This will produce the following output -

+-------------+
| DateOfBirth |
+-------------+
| 1996-01-21  |
| 2004-11-01  |
| 1990-03-31  |
| 2010-12-03  |
+-------------+
4 rows in set (0.00 sec)

Following is the query to display the day name on the basis of Date of Birth −

mysql> select dayname(DateOfBirth) from DemoTable795;

This will produce the following output -

+----------------------+
| dayname(DateOfBirth) |
+----------------------+
| Sunday               |
| Monday               |
| Saturday             |
| Friday               |
+----------------------+
4 rows in set (0.00 sec)

AmitDiwan

Updated on 09-Sep-2019 08:52:22

• Related Questions & Answers
• Search records on the basis of date in MySQL?
• Display records on the basis of key-value pairs in MySQL
• How to display first day and last day of the month from date records in MySQL?
• MySQL query to display records on the basis of conditions IS NULL OR !=1;?
• Fetch records on the basis of LastName using MySQL IN()
• Add a column count in a MySQL query on the basis of last name records?
• Need to populate autocomplete with records on the basis of first and last name of schools in MySQL?
• Select items based on value first, then order on the basis of date for rest of the records in MySQL
• MySQL query to subtract date records with week day and display the weekday with records
• Calculate age based on date of birth in MySQL?
• MySQL query to ORDER BY records on the basis of modulus result
• Select records from a table on the basis of keywords in MySQL
• MySQL query to get the dates between range of records displaying student’s Date of Birth?
• Get day name for the corresponding date in MySQL?
• Perform MySQL UPDATE on the basis of DATE value in another column