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

3 votes107 views1 answer
Créer une table sql
SQL
0 vote106 views1 answer
Oracle list dblink
SQL
0 vote102 views1 answer
Sql show all users
SQL
2 votes109 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
3 votes111 views3 answers
How to add month in update sql
SQL
0 vote102 views1 answer
Lost connection to mysql
SQL
0 vote116 views1 answer
Generate random & unique mysql string
SQL
0 vote97 views1 answer
Sql beginning of previous month
SQL
2 votes101 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote116 views1 answer
Get initial in sql
SQL