# PARSE\_TIME\_MICROS

```
PARSE_TIME_MICROS(micros, pattern)
```

Builds a time-micros value given a time string representation and a time pattern.

Available in:

| Processors | SQL Studio |
| ---------- | ---------- |
| ✓          | ✓          |

*Sample code:*

```sql
USE `kafka`;
SELECT 
    PARSE_TIME_MICROS(tpep_pickup_datetime, 'yyyy-MM-dd HH:mm:ss'), 
    tpep_pickup_datetime 
FROM nyc-yellow-taxi-trip
LIMIT 1;
```

*Output:*

```json
{
  "value": {
    "PARSE_TIME_MICROS": "00:00:02",
    "tpep_pickup_datetime": "2016-01-01 00:00:02"
  }
}
```