# make_timestamp

> 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: make_timestamp
latest-operator-version: v26.2.4
latest-console-tag: v3.12.0
latest-connect-version: 4.113.1
latest-redpanda-tag: v26.2.4
docname: sql/sql-functions/other-functions/make-timestamp
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/other-functions/make-timestamp.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/other-functions/make-timestamp.adoc
description: The `make_timestamp()` function creates a timestamp value from year, month, day, hour, minute, and second fields.
page-topic-type: reference
page-git-created-date: "2026-09-08"
page-git-modified-date: "2026-09-08"
---

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

The `make_timestamp()` function creates a [`timestamp`](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-data-types/timestamp-without-time-zone/) value from separate year, month, day, hour, minute, and second fields. See also [`make_timestamptz()`](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/other-functions/make-timestamptz/) to create a timestamp with a time zone.

## [](#syntax)Syntax

```sql
MAKE_TIMESTAMP(year, month, day, hour, minute, second)
```

## [](#arguments)Arguments

-   `year`: The year, as an integer.

-   `month`: The month, as an integer from 1 to 12.

-   `day`: The day of the month, as an integer.

-   `hour`: The hour, as an integer.

-   `minute`: The minute, as an integer.

-   `second`: The second, as a floating-point number (supports fractional seconds).


## [](#return-type)Return type

`timestamp`

## [](#examples)Examples

```sql
SELECT MAKE_TIMESTAMP(2026, 9, 1, 13, 45, 30.5);
```

```sql
      make_timestamp
----------------------------
 2026-09-01 13:45:30.5
(1 row)
```