DAYNAME() function to get full Day Name from date in MySQL Query

SELECT DAYNAME('2016-08-24')

Output is Wednesday

Syntax

DAYNAME()

Example :
DEMO: Select date from Calendar to execute DAYNAME()

DAYNAME() function to get full name of the weekday in MySQL

CURDATE() or NOW() & DAYNAME()

By using CURDATE() we get the present date part only, where as by using NOW() we will get both date and time.

SELECT DAYNAME(CURDATE())

Output is Wednesday

SELECT DAYNAME(NOW())

Output is Wednesday

Yesterday , Today and Tomorrow

SELECT DAYNAME(CURDATE()- interval 1 day)  as YesterDay, 
DAYNAME(CURDATE()) as Today, 
DAYNAME(CURDATE()+ interval 1 Day) as Tomorrow

YesterDay	Today	Tomorrow
Tuesday	Wednesday	Thursday

PHP Script

To display the above details we used PHP Script, you can use the same script for using all above queries.
config.php connection string is available here
PDO for executing Queries in PHP
How to get records using FETCH() is here

<?Php
require 'config.php';  // Database connection string
$query='SELECT DAYNAME(CURDATE()) as dt';
// Change the above Query part to get different results // 

$count=$dbo->prepare($query);
$count->execute();
$row = $count->fetch(PDO::FETCH_OBJ);
echo 'Output is : '.$row->dt; 
?>

SQL Date MONTHNAME() : Month name in Full ( November )
SQL txt file for DAYNAME()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

DAYNAME() : weekday name in Full from input Date in MySQL

CURDATE() or NOW() & DAYNAME()

Yesterday , Today and Tomorrow

PHP Script

Subhendu Mohapatra