Date and Time Functions -> 1028 All numbers are rounded toward zero. In MySQL 8.0.21 and later, the data type returned by  TRUNCATE()  follows the same rules that determine the return type of the  ROUND()  function; for details, see the description for  ROUND() . This section describes the functions that can be used to manipulate temporal values. See Section 11.2, “Date and Time Data Types” , for a description of the range of values each date and time type has and the valid formats in which values may be specified. Table 12.11 Date and Time Functions 12.7 Date and Time Functions Name Description ADDDATE() Add time values (intervals) to a date value ADDTIME() Add time CONVERT_TZ() Convert from one time zone to another CURDATE() Return the current date CURRENT_DATE() ,  CURRENT_DATE Synonyms for CURDATE() CURRENT_TIME() ,  CURRENT_TIME Synonyms for CURTIME() CURRENT_TIMESTAMP() ,  CURRENT_TIMESTAMP Synonyms for NOW() CURTIME() Return the current time DATE() Extract the date part of a date or datetime expression DATE_ADD() Add time values (intervals) to a date value DATE_FORMAT() Format date as specified DATE_SUB() Subtract a time value (interval) from a date DATEDIFF() Subtract two dates DAY() Synonym for DAYOFMONTH() DAYNAME() Return the name of the weekday DAYOFMONTH() Return the day of the month (0-31) DAYOFWEEK() Return the weekday index of the argument DAYOFYEAR() Return the day of the year (1-366) EXTRACT() Extract part of a date FROM_DAYS() Convert a day number to a date FROM_UNIXTIME() Format Unix timestamp as a date GET_FORMAT() Return a date format string HOUR() Extract the hour LAST_DAY Return the last day of the month for the argument LOCALTIME() ,  LOCALTIME Synonym for NOW() LOCALTIMESTAMP ,  LOCALTIMESTAMP() Synonym for NOW() MAKEDATE() Create a date from the year and day of year 2150