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 vote234 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote215 views1 answer
How to check the port of mysql installation in mac
SQL
4 votes211 views1 answer
Sql any
SQL
0 vote233 views1 answer
How to find sql server installation folder
SQL
1 vote217 views1 answer
What is intersect
SQL
1 vote227 views1 answer
Hackerrank sql test solutions
SQL
2 votes247 views1 answer
Oracle run_duration to number
SQL
6 votes221 views1 answer
Postgres get size of database
SQL
1 vote240 views1 answer
How to set up a trigger in sql
SQL
0 vote263 views1 answer
CONVERT time string into 12 hours in sql
SQL