Postgresql get last day of month

SELECT (date_trunc('month', '2017-01-05'::date) + interval '1 month' - interval '1 day')::date
AS end_of_month;

Source: stackoverflow.com

Postgresql get last day of month

create function end_of_month(date)
returns date as
$$
select (date_trunc('month', $1) + interval '1 month' - interval '1 day')::date;
$$ language 'sql'
immutable strict;

Source: stackoverflow.com

Similar codes

31 votes286 views3 answers
Sql count(*)
SQL
1 vote315 views1 answer
Key validation sql
SQL
0 vote308 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote296 views1 answer
Sql case sttement with set
SQL
0 vote297 views1 answer
Mysql count unique in group statement
SQL
1 vote301 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote316 views1 answer
Default order by in mysql
SQL
0 vote306 views1 answer
Restore backup mysql .gz
SQL
1 vote290 views1 answer
How to make a select in sql
SQL
2 votes339 views1 answer
Oracle run_duration to number
SQL