Mysql Date , time , Datetime Functions
## MySQL Date and Time Functions MySQL provides a set of functions that allow you to manipulate date and time values. These functions can be used to add or subtract time from dates, extract specific parts of dates, and format dates in various ways. Here is a list of MySQL date and time functions with a brief description of each: ### Date Functions - `DATE()` - extracts the date part from a datetime expression. - `DATEDIFF()` - calculates the number of days between two date values. - `DAY()` - gets the day of the month of a date. - `DAYNAME()` - gets the name of the weekday of a date. - `DAYOFMONTH()` - gets the day of the month of a date. - `DAYOFWEEK()` - gets the weekday index of a date. - `DAYOFYEAR()` - gets the day of the year of a date. - `FROM_DAYS()` - returns a date from a day number. - `LAST_DAY()` - gets the last day of the month for a date. - `MAKEDATE()` - creates a date from the year and day of year. - `MONTH()` - gets the month of a date. - `MONTHNAME()` - gets the ...