Date and Time Units

The INTERVAL keyword can be used to add or subtract a time interval of time to a DATETIME, DATE or TIME value.

The syntax is:

For example, the SECOND unit is used below by the DATE_ADD() function:

The following units are valid:

The time units containing an underscore are composite; that is, they consist of multiple base time units. For base time units, time_quantity is an integer number. For composite units, the quantity must be expressed as a string with multiple integer numbers separated by any punctuation character.

Example of composite units:

Time units can be used in the following contexts:

• after a or a operator;

• with the following DATE or TIME functions: , , , , , , ;

• in the ON SCHEDULE clause of and ;

See Also

_{This page is licensed: CC BY-SA / Gnu FDL}