In this tips Postgresql sintax, we will give example How to get LastDay of this month.
NOW() function is current date with time.
select now()
"2018-04-20 13:51:09.20666+07"
Often when working with dates, we either need to get the first day of the month or the last day of the month.
Getting the first day is easy and can be done with date_trunc.
SELECT date_trunc('MONTH', now())::DATE;
"2018-04-01"
And then, to get LastDay of this month using this sintax :
SELECT (date_trunc('MONTH', now()) + INTERVAL '1 MONTH - 1 day')::DATE;
"2018-04-30"
Lets see, easy right..?