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

-1 vote235 views1 answer
Add 10 to all numbers in a column sql
SQL
17 votes186 views4 answers
Postgres list users
SQL
0 vote239 views1 answer
How to make full text search dynamic in mysql
SQL
13 votes171 views2 answers
Mysql order by multiple columns
SQL
0 vote198 views1 answer
Date 3 months from today sql
SQL
7 votes267 views1 answer
Oracle alter sequence restart start with
SQL
8 votes212 views1 answer
Oracle tablespace datafile max size
SQL
4 votes203 views1 answer
Describe table mysql
SQL
2 votes223 views1 answer
Username sql
SQL
1 vote167 views1 answer
Launch sql script from docker in mysql
SQL