C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time monthname() FunctionThe monthname() is a MySQL date/time function. It is used to get the full month name. Syntaxselect monthname(date_value); Parameter:date_value : datetime or time value for getting month name. Returns:This function returns the full name of the month for a date. Example 1Select monthname ('2018-9-28 10:20:25.000002'); Output: Example 2Select monthname('1995-2-11'); Output:
Next TopicMySQL datetime
|