Date functions Flashcards
ADDDATE
Adds a time/date interval to a date and then returns the date
ADDTIME
Adds a time interval to a time/datetime and then returns the time/datetime
CURDATE
Returns the current date
CURRENT DATE
Returns the current date
CURRENT TIME
Returns the current time
CURRENT TIMESTAMP
Returns the current date and time
CURTIME
Returns the current time
DATE
Extracts the date part from a datetime expression
DATEDIFF
Returns the number of days between two date values
DATE ADD
Adds a time/date interval to a date and then returns the date
DATE FORMAT
Formats a date
DATE SUB
Subtracts a time/date interval from a date and then returns the date
DAY
Returns the day of the month for a given date
DAYNAME
Returns the weekday name for a given date
DAYOFMONTH
Returns the day of the month for a given date
DAYOFWEEK
Returns the weekday index for a given date
DAYOFYEAR
Returns the day of the year for a given date
EXTRACT
Extracts a part from a given date
FROM DAYS
Returns a date from a numeric datevalue