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

8 votes179 views2 answers
Oracle undo usage
SQL
0 vote175 views1 answer
SQL add a totals of differemt rows of the same id
SQL
3 votes200 views2 answers
Oracle drop sequence
SQL
3 votes189 views2 answers
Mysql select database
SQL
0 vote163 views1 answer
Luu ckeditor vao mysql
SQL
0 vote163 views1 answer
Sql server port 1434
SQL
0 vote177 views1 answer
How to use lower case in mysql
SQL
1 vote155 views1 answer
Scaffold mysql database
SQL
1 vote188 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
-2 votes223 views1 answer
Trunc in sql
SQL