days_in_month()

Calculates days in month given a timestamptz

Since 1.16.0

Given a timestamptz, returns how many days are in that month.

Samples

Calculate how many days in the month of January 1, 2022:

SELECT days_in_month('2021-01-01 00:00:00+03'::timestamptz)

The output looks like this:

days_in_month
---------------------
31

Arguments

The syntax is:

SELECT days_in_month(
    date = <date>
);

Name	Type	Default	Required	Description
date	TIMESTAMPTZ	-	✔	Timestamp to use to calculate how many days in the month