DAYOFYEAR() function to get day of the year from 1 to 366 in MySQL Query

SELECT DAYOFYEAR('2023-01-01'); # 1
SELECT DAYOFYEAR('2023-12-31'); # 365
SELECT DAYOFYEAR('2023-02-31'); # NULL

Syntax

DAYOFYEAR(date)

Example :

SELECT DAYOFYEAR('2016-05-26')

Output is 147
DEMO: Select date from Calendar to execute DAYOFYEAR()

CURDATE() or NOW() & DAYOFYEAR()

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

SELECT CURDATE(),DAYOFYEAR(CURDATE());

Output is 2026-09-09 252

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() are here

<?Php
require 'config.php';  // Database connection string
$query='SELECT DAYOFYEAR(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; 
?>

MAKEDATE() : Create date with dayofyear and Year as inputs

SQL Date References MONTH() DAY() NOW() : Current Date with Time

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

DAYOFYEAR() : Day number of the year in MySQL

CURDATE() or NOW() & DAYOFYEAR()

PHP Script

Subhendu Mohapatra