PostgreSQL | PGExercises.com | Days left in month

-- https://pgexercises.com/questions/date/daysremaining.html
-- solved for today, not for their date

select
    (date_trunc('month', CURRENT_TIMESTAMP) + '1 month'::INTERVAL) - date_trunc('day', CURRENT_TIMESTAMP) as remaining