Introduction to PostgreSQL MAKE_DATE() function

TheMAKE_DATE() function allows you to construct adate value from the specified year, month, and day values.

Here’s the syntax of theMAKE_DATE() function:

MAKE_DATE(year int,month int,day int ) →date

In this syntax,year,month, andday are the year, month, and day parts of the date. The negative year indicates BC.

TheMAKE_DATE() function returns a value of theDATE type.

PostgreSQL MAKE_DATE() function examples

Let’s explore some examples of using theMAKE_DATE() function.

1) Basic PostgreSQL MAKE_DATE() function example

The following example uses theMAKE_DATE() function to generate the date2024-03-25:

SELECT MAKE_DATE(2023,3,25);

Output:

make_date------------ 2023-03-25(1 row)

2) Using the MAKE_DATE() function with leap years

TheMAKE_DATE() function automatically handles the leap years for you. For example, you can create a date ofFebruary 29th in a leap year such as2024 as follows:

SELECT MAKE_DATE(2024,2,29);

Output:

make_date------------ 2024-02-29(1 row)

3) Using the MAKE_DATE() function to generate sequential dates

The following example uses theMAKE_DATE() function to generate a list of date values fromJan 1, 2024 toJan 7, 2024:

SELECT MAKE_DATE(2023,1,day) datesFROM generate_series(1,7)AS day;

Output:

dates------------ 2023-01-01 2023-01-02 2023-01-03 2023-01-04 2023-01-05 2023-01-06 2023-01-07(7 rows)

Summary

• Use theMAKE_DATE() function to generate a date value from the year, month, and day

Last updated onMarch 25, 2024

On this page

• Introduction to PostgreSQL MAKE_DATE() function
• PostgreSQL MAKE_DATE() function examples
• Summary