HOUR_MICROSECOND

HOUR_MICROSECOND is a unit in SQL that is used to depict a time interval. It represents the combination of hours and microseconds for data extraction or manipulation during date and time operations.

Example

SELECT ADDTIME('2007-12-31 23:59:59.999999', '1 1:1:1.000002');

Output

2008-01-01 01:01:01.000001

Explanation

The HOUR_MICROSECOND value ‘1 1:1:1.000002’ adds one day, one hour, one minute, one second, and two microseconds to the datetime ‘2007-12-31 23:59:59.999999’, resulting in the datetime ‘2008-01-01 01:01:01.000001’.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.