WEEKOFYEAR(): function in a mysql date and time field

Returns the Week Number of the year from a date .
Syntax
WEEKOFYEAR(date)
Example
SELECT WEEKOFYEAR('2015-08-21')
Output is 34
For a invalid date we will get Null as output
SELECT WEEKOFYEAR('2015-02-31')
Output is NULL Monday is the starting day of the week.
This function is same as WEEK() function when mode is equal to 3
Your Rating




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








HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2019 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer