postgresql get last day of month

Solutions on MaxInterview for postgresql get last day of month by the best coders in the world

showing results for - "postgresql get last day of month"

1SELECT (date_trunc('month', '2017-01-05'::date) + interval '1 month' - interval '1 day')::date
2AS end_of_month;
3

1create function end_of_month(date)
2returns date as
3$$
4select (date_trunc('month', $1) + interval '1 month' - interval '1 day')::date;
5$$ language 'sql'
6immutable strict;
7

queries leading to this page

postgresql get last date of current month postgres get last month sql last day of month postgres get the last date of month in postgres psql datetime in last month last month postgresql last day postgresql get the last day of next year in postgres sql get end of month day postgresql how to find last date of past month in postgresql postgres get last month day get last day of month postgresql postgresql get last day of year postgres last day of month postgres select from last month postgresql get last day of month postgresql last day of month get last month value in postgres year month day current postgresql postgres get last day of month postgresql last month how to get previous month from current date in postgresql postgress check date in the last month psql how to get last day of month get last day of year postgres postgres get first day of month postgresql last day of previous month display last day each month of year in postgresql postgres last month postgres get last date of month date last month postgresql postgres last day of current year postgres function get last day of month postgres get current day of month postgresql get last day of month