MySQL MICROSECOND() Function

MySQL MICROSECOND() function; In this tutorial, i am going to show you MySQL microsecond() function with the help of examples.

MySQL MICROSECOND() Function

The MySQL Microsecond() function is used to return the microsecond part for a specified time or date-time value. The range of microsecond value is from 0 to 999999. For example, if the specified time is “09:12:23.000123”, this function will return 123 microseconds.

Syntax of MySQL MICROSECOND() Function

The syntax of this microsecond() is:

MICROSECOND(time)

Here, time is the value you want to remove from the microsecond component.

Example 1 – MySQL MICROSECOND() Function

Let’s take an example using MySQL microseconds() function; as follows:

SELECT MICROSECOND('09:40:00.123456');

Output-1

+--------------------------------+
| MICROSECOND('09:40:00.123456') |
+--------------------------------+
|                         123456 |
+--------------------------------+

Example 2 – MySQL MICROSECOND() Function

Let’s take an example with microsecond() function using an abbreviated DateTime value; as follows:

SELECT MICROSECOND('2021-10-07 09:40:00.123456');

Output-2

+-------------------------------------------+
| MICROSECOND('2021-10-07 09:40:00.123456') |
+-------------------------------------------+
|                                    123456 |
+-------------------------------------------+

Example 3 – MySQL MICROSECOND() Function

Let’s take an example using the microsecond with last two digits are the only nonzero digits; as follows:

SELECT MICROSECOND('09:40:00.000056');

Output-3

+--------------------------------+
| MICROSECOND('09:40:00.000056') |
+--------------------------------+
|                             56 |
+--------------------------------+

Example 4 – MySQL MICROSECOND() Function

To EXTRACT () function to extract microseconds (and other date/time parts) by date or time; as follows:

SELECT EXTRACT(MICROSECOND FROM '09:40:00.123456');

Output-4

+---------------------------------------------+
| EXTRACT(MICROSECOND FROM '09:40:00.123456') |
+---------------------------------------------+
|                                      123456 |
+---------------------------------------------+

Conclusion

MySQL MICROSECOND() Function tutorial, you have learned how to use MySQL MICROSECOND() function with various examples.

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *