MySQL - Date and Time Functions

This function adds two given dates

This function adds given time values

This function converts from one timezone to another

This function returns the current date

Synonyms for CURDATE()

Synonyms for CURTIME()

Synonyms for NOW()

This function returns the current time

Adds two dates

This function formats the given date as specified

This function subtracts two dates

This function extracts the date part of a date or datetime expression

This function subtracts two dates

This function retrieves the day of the month from the given date

This function returns the name of the weekday

This function returns the day of the month (1-31)

This function returns the weekday index of the argument

This function returns the day of the year (1-366)

This function extracts part of a date

This function converts a day number to a date

This function formats date as a UNIX timestamp

This function Extracts the hour

This function returns the last day of the month for the argument

Synonym for NOW()

Synonym for NOW()

This function creates a date from the year and day of year

This function creates a time value from the given hours, minutes, and seconds.

This function returns the microseconds from argument

This function returns the minute from the argument

This function returns the month from the date passed

This function returns the name of the month

This function returns the current date and time

This function adds a period to a year-month

This function returns the number of months between periods

This function returns the quarter from a date argument

This function converts seconds to 'HH:MM:SS' format

This function returns the second (0-59)

This function converts a string to a date

This function subtracts the specified interval to a date value

This function subtracts the specified time interval to a date time or, time value

This function returns the time at which the function executes

This function formats the given date in the specified format

This function returns the argument converted to seconds

This function extracts the time portion of the expression passed

This function subtracts two time values

With a single argument, this function returns the date or datetime expression. With two arguments, the sum of the arguments

This function adds an interval to a datetime expression

This function subtracts an interval from a datetime expression

This function returns the date argument converted to days

This function returns a UNIX timestamp

This function returns the current UTC date

This function returns the current UTC time

This function returns the current UTC date and time

This function returns the week number

This function returns the weekday index

This function returns the calendar week of the date (1-53)

This function returns the year

This function returns the year and week

This function converts the date or date-time values into seconds and returns the result.