MICROSECOND

Syntax

MICROSECOND(expr)

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

• Microseconds in MariaDB

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}