• DATE
• Please Note
• Relevant date functions
• DATE(dateString)
• NOW(), GETDATE(), CURRENT_TIMESTAMP/CURRENT_TIMESTAMP()
• CURDATE/CURDATE(), CURRENTDATE/CURRENTDATE()
• SECOND(date) / MINUTE(date) / HOUR(date) / DAY(date) / MONTH(date) / YEAR(date) / DAYOFWEEK(date)
• DATEDIFF(unit, date1, date2)
• DATEADD(unit, number, date)
• DATE_ADD(date, numberInMs) / ADDDATE(date, numberInMs)
• DATE_SUB(date, numberInMs) / SUBDATE(date, numberInMs)
• INTERVAL
• BETWEEN