pagila
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
last_day
Parameters
Name
Type
Mode
$1
timestamp without time zone
IN
Definition
SELECT CASE WHEN EXTRACT(MONTH FROM $1) = 12 THEN (((EXTRACT(YEAR FROM $1) + 1) operator(pg_catalog.||) '-01-01')::date - INTERVAL '1 day')::date ELSE ((EXTRACT(YEAR FROM $1) operator(pg_catalog.||) '-' operator(pg_catalog.||) (EXTRACT(MONTH FROM $1) + 1) operator(pg_catalog.||) '-01')::date - INTERVAL '1 day')::date END