Date Function « Date Time « SQL / MySQL

1.Date data type manipulation
2.Get Day of Month for a date
3.Get the YEAR part of the date
4.Birthdays in the upcoming month
5.DATE_ADD() add a time interval to a given date
6.Calculation on Date data type
7.Date Calculations: calculate ages
8.Date Calculations: extract parts of dates
9.Get sub date

10.Decomposing Dates or Times Using String Functions substrings.
11.Pull out the entire date or time part from DATETIME values using string-extraction functions such as LEFT( ) o