Learning PHP and MySQL

Example 08-13 Finding days since the start of the year

SELECT DAYOFYEAR('2006-1-1'), DAYOFYEAR('2006-12-24');

Posted by on 08/07 at 05:16 PM

Next entry: Example 08-14 Using MONTH and MONTHNAME on the purchases table

Previous entry: Example 08-12 Using DAYNAME to get the day of the week as a name

<< Back to main