DAYOFYEAR() : Day number of the year in MySQL

Returns full day name from a date.
Syntax
DAYOFYEAR(date)
Example :
SELECT DAYOFYEAR('2016-05-26') 
Output is 147

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 DAYOFYEAR(CURDATE())
Output is 294

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; 
?>


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com



    Post your comments , suggestion , error , requirements etc here .





    SQL Video Tutorials










    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2021 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer