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

19 votes236 views5 answers
Mysql between date range
SQL
0 vote233 views2 answers
Postgres having
SQL
1 vote232 views1 answer
Rermove categories woocommerce sql
SQL
0 vote262 views1 answer
Finding leap year in sql
SQL
15 votes219 views2 answers
Open postgress in terminal mac
SQL
0 vote273 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote224 views1 answer
How to use group_concat in sql server
SQL
6 votes211 views1 answer
Oracle rank() over (partition)
SQL
0 vote221 views1 answer
Sql remove non numeric characters
SQL
0 vote223 views1 answer
Uuid sqlalcomany
SQL