The three most commonly used date functions are YEAR, MONTH, and DAY. These functions are used to return only the year, month, or day from a date. To use the YEAR, MONTH, and DAY functions:
Two other date functions are
TODAY. They are useful when you need to show the current date information or need to calculate something based on that information.
NOW: Returns the current date and time.
TODAY: Returns the current date, but the time is set to 12:00:00 AM.