Computer scienceFundamentalsSQL and DatabasesDBMSMySQLData types and operations

Date & Time data types

Theory

Functions

Report a typo

Match the SQL functions with their definitions.

Match the items from left and right columns
EXTRACT()
DATE_ADD()
DATE_SUB()
DATEDIFF()
CONVERT_TZ()
Substracts the given value from the date.
Returns the difference between the two dates.
Returns the specified part of the given date.
Converts the date from one time zone to another.
Adds the given value to the date.
___

Create a free account to access the full topic