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

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

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