LAST_DAY function returns the last day of a month.

Example :

To get the last day of the current month,

Values last_day(current date)

Result : 04/30/2019

To get the first day of the current month,

Values last_day(current date) + 1 day – 1 month

Result : 04/01/2019