webCOMAND

MICROSECOND()

Return the microsecond part of a time or timestamp.

Prototype

integer MICROSECOND(mixed $timestamp)

Parameters

  • timestamp - A time ("HH:MM:SS") or timestamp ("YYYY-MM-DD HH:MM:SS") followed by optional decimal and microseconds

Return

The microsecond portion of a time or timestamp, or NULL if there is an error, such as an invalid timestamp.

Example

SELECT OID, MICROSECOND('12:05:22.234') AS Microseconds FROM User

Related

SECOND(), MINUTE(), HOUR()