microseconds_add
Description
Adds a time interval to a date value. The time interval is in microseconds.
Syntax
DATETIME microseconds_add(DATETIME expr1,INT expr2);
Parameters
expr1
: the time expression. It must be of the DATETIME type.
expr2
: the time interval you want to add, in microseconds. It must be of the INT type.
Return value
Returns a value of the DATETIME type. If the input value is of the DATE type, the hour, minute, and seconds parts are processed as 00:00:00
.
Examples
select microseconds_add('2010-11-30 23:50:50', 2);
+--------------------------------------------+
| microseconds_add('2010-11-30 23:50:50', 2) |
+--------------------------------------------+
| 2010-11-30 23:50:50.000002 |
+--------------------------------------------+
1 row in set (0.00 sec)
select microseconds_add('2010-11-30', 2);
+-----------------------------------+
| microseconds_add('2010-11-30', 2) |
+-----------------------------------+
| 2010-11-30 00:00:00.000002 |
+-----------------------------------+