postgresql - Last Date of the Month in Postgres Sql -

how can last day of month through month name in postgresql?

try way :

select date_trunc('month', to_date('january ', 'month'))+'1month'::interval-'1day'::interval 

to parse date object month name can try way :

to_date('january', 'month')