C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time weekofyear() FunctionThe weekofyear() is a MySQL date/time function. It is used to get the week of the given date. Syntaxselect weekofyear(date_value); Parameter:Date_value : date for getting weekofyear Returns:This function returns week of the year for a date value. Example 1select weekofyear('2018-10-03'); Output: Example 2select weekofyear('1995-02-11'); Output:
Next TopicMySQL datetime
|