MICROSECOND
Syntax
MICROSECOND(expr)
Contents
Description
Returns the microseconds from the time or datetime expression expr as a number in the range from 0 to 999999.
If expr is a time with no microseconds, zero is returned, while if expr is a date with no time, zero with a warning is returned.
Examples
SELECT MICROSECOND('12:00:00.123456'); +--------------------------------+ | MICROSECOND('12:00:00.123456') | +--------------------------------+ | 123456 | +--------------------------------+ SELECT MICROSECOND('2009-12-31 23:59:59.000010'); +-------------------------------------------+ | MICROSECOND('2009-12-31 23:59:59.000010') | +-------------------------------------------+ | 10 | +-------------------------------------------+ SELECT MICROSECOND('2013-08-07 12:13:14'); +------------------------------------+ | MICROSECOND('2013-08-07 12:13:14') | +------------------------------------+ | 0 | +------------------------------------+ SELECT MICROSECOND('2013-08-07'); +---------------------------+ | MICROSECOND('2013-08-07') | +---------------------------+ | 0 | +---------------------------+ 1 row in set, 1 warning (0.00 sec) SHOW WARNINGS; +---------+------+----------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------+ | Warning | 1292 | Truncated incorrect time value: '2013-08-07' | +---------+------+----------------------------------------------+
See Also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.