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 vote143 views1 answer
How to reset table in sql server
SQL
2 votes140 views1 answer
Sql alchemy or
SQL
12 votes140 views4 answers
Mysql get date difference in hours
SQL
0 vote102 views1 answer
Update sql join multiple tables
SQL
2 votes145 views1 answer
How to select first row of database sql
SQL
0 vote164 views1 answer
Mssql last day of month
SQL
0 vote145 views2 answers
Sql having multiple conditions
SQL
0 vote104 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote171 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
21 votes155 views4 answers
Oracle add column
SQL