
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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)
- Related Articles
- Search records on the basis of date in MySQL?
- How to display first day and last day of the month from date records in MySQL?
- Display records on the basis of key-value pairs in MySQL
- MySQL query to display records on the basis of conditions IS NULL OR !=1;?
- MySQL query to subtract date records with week day and display the weekday with records
- MySQL query to get the dates between range of records displaying student’s Date of Birth?
- Fetch records on the basis of LastName using MySQL IN()
- Select items based on value first, then order on the basis of date for rest of the records in MySQL
- 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?
- 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
- How to display coming Sunday's date for all the date records in MySQL?
- How to convert birth date records to age with MongoDB

Advertisements