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 vote243 views1 answer
Sql only five first row
SQL
0 vote280 views1 answer
Query for backup a database at another location in file system
SQL
20 votes285 views1 answer
Get all table name in sql through php
SQL
2 votes262 views1 answer
Oracle drop sequence if exists
SQL
13 votes250 views2 answers
Mysql order by multiple columns
SQL
28 votes214 views6 answers
Distinct sql
SQL
6 votes266 views2 answers
If not exists insert sql
SQL
16 votes255 views2 answers
Oracle ddl
SQL
0 vote262 views1 answer
Mysql terminal run sql file
SQL
0 vote269 views1 answer
Mysql workbench format date
SQL