# MICROSECOND

Extracts the microseconds (fractional seconds part) from the given datetime.

## Syntax

```
MICROSECOND(dateobj)

```

## Arguments

* dateobj: a valid date, datetime, time, or parsable datetime string.

## Return Type

Integer

## Example

```sql
SELECT MICROSECOND('2019-03-25 10:15:21.000423') AS MICROSECONDS;

```

```output

+------------------------------+
| MICROSECONDS                 |
+------------------------------+
| 423                          |
+------------------------------+
1 row in set (503 ms)

```

**Related Topics**

* [HOUR](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/hour.md)
* [MINUTE](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/minute.md)
* [SECOND](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/second.md)
* [Data Types](https://docs.singlestore.com/cloud/reference/sql-reference/data-types.md)

***

Modified at: May 31, 2023

Source: [/cloud/reference/sql-reference/date-and-time-functions/microsecond/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/microsecond/)

(An index of the documentation is available at /llms.txt)