# make_date

> 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_date
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-date
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-date.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/other-functions/make-date.adoc
description: The `make_date()` function creates a date value from year, month, and day 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-date.md -->

The `make_date()` function creates a [`date`](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-data-types/date/) value from separate year, month, and day fields.

## [](#syntax)Syntax

```sql
MAKE_DATE(year, month, day)
```

## [](#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.


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

`date`

## [](#examples)Examples

```sql
SELECT MAKE_DATE(2026, 9, 1);
```

```sql
 make_date
------------
 2026-09-01
(1 row)
```