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
SELECT CURDATE(),DAYOFYEAR(CURDATE());
Output is 2025-02-10 41
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