# timestamp_micros

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: timestamp_micros
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/timestamp-functions/timestamp-micros
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/timestamp-functions/timestamp-micros.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/timestamp-functions/timestamp-micros.adoc
description: The `timestamp_micros()` function converts a given UNIX timestamp value in microseconds since 1970-01-01 00:00:00 UTC into a timestamp.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/timestamp-functions/timestamp-micros.md -->

The `timestamp_micros()` function converts a given UNIX timestamp value in microseconds since 1970-01-01 00:00:00 UTC into a timestamp. Its syntax is:

```sql
SELECT TIMESTAMP_MICROS(BIGINT)
```

Its input type is a `bigint` expression representing a UNIX timestamp in microseconds and the return data type is a timestamp.

## [](#examples)Examples

### [](#basic-timestamp_micros-function)Basic `timestamp_micros()` function

This example shows how to use the `timestamp_micros()` function to convert a given UNIX timestamp in microseconds into a timestamp without a timezone:

```sql
SELECT TIMESTAMP_MICROS(2280419000000000) AS timestamp_microsvalues;
```

The query returns:

```sql
+-----------------------------+
| timestamp_microsvalues      |
+-----------------------------+
| 2042-04-06 17:43:20         |
+-----------------------------+
```

### [](#timestamp_micros-function-using-columns)`timestamp_micros()` function using columns

Suppose a table named **timemicro\_example** has these UNIX time values in microseconds in the **unix\_timestamp** column:

```sql
CREATE TABLE timemicro_example (
  unix_timestamp long
);

INSERT INTO timemicro_example VALUES
(1350417000000000),
(2130215000000000),
(1110115000000000),
(2310112000000000);
```

```sql
SELECT * FROM timemicro_example;
```

This query shows the table:

```sql
+--------------------+
| unix_timestamp     |
+--------------------+
| 1350417000000000   |
| 2130215000000000   |
| 1110115000000000   |
| 2310112000000000   |
+--------------------+
```

To convert all UNIX timestamp values in microseconds to timestamp values, run the query:

```sql
SELECT unix_timestamp, TIMESTAMP_MICROS(unix_timestamp)
AS timestamp_value
FROM timemicro_example;
```

The output displays all the entries in the table in UNIX timestamp format (in microseconds) in the **unix\_timestamp** column and in the timestamp format in the column **timestamp\_value** without timezone:

```sql
+-------------------------+-----------------------+
| unix_timestamp          | timestamp_value       |
+-------------------------+-----------------------+
|1350417000000000         | 2012-10-16 19:50:00   |
|2130215000000000         | 2037-07-03 06:23:20   |
|1110115000000000         | 2005-03-06 13:16:40   |
|2310112000000000         | 2043-03-16 09:46:40   |
+-------------------------+-----------------------+
```