SQL support many functions with which we can manage the dates efectively

Below given are the date functions is MySql

• NOW()- Returns the current date and time
• CURDATE()- Returns the current date
• CURTIME()- Returns the current time
• DATE()- Extracts the date part of a date or date/time expression
• EXTRACT()- Returns a single part of a date/time
• DATE_ADD()- Adds a specified time interval to a date
• DATE_SUB() -Subtracts a specified time interval from a date
• DATEDIFF()- Returns the number of days between two dates
• DATE_FORMAT()- Displays date/time data in different formats