Versions:
days_in_month() ToolkitTimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.ExperimentalExperimental features are not suitable for production environments. They are included under the TimescaleDB experimental schema. Click to learn more.
Toolkit
TimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.
Experimental
Experimental features are not suitable for production environments. They are included under the TimescaleDB experimental schema. Click to learn more.
Given a timestamptz, returns how many days are in that month.
Required arguments
| Name | Type | Description |
|---|---|---|
date | TIMESTAMPTZ | Timestamp to use to calculate how many days in the month |
Sample usage
Calculate how many days in the month of January 1, 2022:
SELECT toolkit_experimental.days_in_month('2021-01-01 00:00:00+03'::timestamptz)
The output looks like this:
days_in_month----------------------31
Found an issue on this page?
Report an issue!Keywords