A Gentle Introduction to
How to work with dates; adding, subtracting and formatting.
Components of a date: such as the year or the month
We can extract the year, the month, the day of the month and the day of the week. Times may be extracted in a similar way.
SELECT YEAR(wk), MONTH(wk), DAY(wk), WEEKDAY(wk) FROM totp WHERE song='Rio'