Skip to content
DBCode

HOUR_MICROSECOND

Example

Section titled “Example”
SELECT ADDTIME('2007-12-31 23:59:59.999999', '1 1:1:1.000002');

Output

Section titled “Output”
2008-01-01 01:01:01.000001

Explanation

Section titled “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’.