MICROSECOND
You are viewing an old version of this article. View
the current version here.
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
Comments
Comments loading...
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.