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

2 votes120 views1 answer
Mysql find tables with name
SQL
0 vote137 views1 answer
Automated psql csv export script on windows
SQL
0 vote137 views1 answer
Insert into select with group by
SQL
0 vote218 views1 answer
Mysql select field if condition
SQL
0 vote114 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote138 views1 answer
Select distinct after join
SQL
11 votes119 views2 answers
Having clause
SQL
0 vote135 views1 answer
Get first 3 letter of department name in sql
SQL
-1 vote152 views1 answer
Sql show custom constraints
SQL
0 vote146 views1 answer
Import sql inside hide sql
SQL