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

0 vote198 views1 answer
Sql select duplicates based on two columns
SQL
0 vote220 views2 answers
How to take recent row without limit in mysql
SQL
2 votes212 views1 answer
Mariadb JSON_EXTRACT
SQL
1 vote218 views1 answer
Where date = max(date) in sql
SQL
1 vote224 views3 answers
Sql union
SQL
0 vote208 views1 answer
Mysql isshow
SQL
0 vote198 views1 answer
Sqlserver now
SQL
0 vote193 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote211 views1 answer
On sql table data exists
SQL
0 vote197 views1 answer
TSQL function split string
SQL