- ⌂ Date & Time
- Functions
MICROSECOND()
Return the microsecond part of a time or timestamp.
Prototype
integer MICROSECOND(mixed $timestamp)
Parameters
- timestamp - A date ("YYYY-MM-DD") or timestamp ("YYYY-MM-DD HH:MM:SS").
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
See Also
SECOND(), MINUTE(), HOUR()