SQL Date keywords

C

CURRENT_DATE

The SQL CURRENT_DATE function returns the current date without time.

D

DATE_FORMAT

The SQL DATE_FORMAT() function formats a date or datetime value according to a specified pattern (MySQL-compatible).

DATEDIFF

The SQL DATEDIFF() function returns the number of days between two dates.

N

NOW

The SQL NOW() function returns the current date and time.