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 vote159 views1 answer
Drop index in sql
SQL
6 votes192 views2 answers
How to get last element sql
SQL
3 votes157 views1 answer
Oracle apex message quit website
SQL
1 vote157 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote191 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote149 views1 answer
How to generate ids in sql
SQL
0 vote164 views1 answer
Sql server pivot rows to columns
SQL
0 vote149 views1 answer
Sqlite commands
SQL
1 vote148 views1 answer
SQL: merging multiple row data in string
SQL
1 vote141 views1 answer
What is in condition in sql
SQL