MICROSECOND() - Microseconds of Time

Q

How to extract the microseconds from a given time using the MICROSECOND() function?

✍: FYIcenter.com

A

MICROSECOND(time) is a MySQL built-in function that returns the microsecond value from a given time. For example:

SELECT MICROSECOND(NOW()), NOW();
  -- +---------------------+----------------------------+
  -- | MICROSECOND(NOW(6)) | NOW(6)                     |
  -- +---------------------+----------------------------+
  -- |              107349 | 2023-11-14 23:16:40.107349 |
  -- +---------------------+----------------------------+

Reference information of the MICROSECOND() function:

MICROSECOND(time): int
  Returns the microseconds from the time or datetime expression time as
  a number in the range from 0 to 999999.

Arguments, return value and availability:
  time: Required. The time to extract the microsecond from.
  int: Return value. The microsecond value.
  Available since MySQL 4.

Related MySQL functions:

 

MINUTE() - Minutes of Time

MAKETIME() - Making Time from Components

MySQL Functions on Date and Time

⇑⇑ MySQL Function References

2023-11-17, 244🔥, 0💬