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 vote118 views1 answer
Sql where part of string match
SQL
2 votes114 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote194 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote167 views1 answer
Add week ending date sql server
SQL
0 vote114 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote108 views1 answer
Mysql repair a table
SQL
0 vote125 views1 answer
Sql server list table sizes
SQL
0 vote117 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote131 views1 answer
TSQL convert csv to table
SQL
0 vote117 views1 answer
Mysql select where field like in list
SQL