---

select
    id,
    service_type,
    m_y_report as report_month,
    to_char(
        to_date(m_y_report, 'MM.YYYY'),
        'DD.MM.YYYY'
    ) as start_date,
    to_char(
        to_date(m_y_report, 'MM.YYYY')
            + interval '1 month - 1 day',
        'DD.MM.YYYY'
    ) as end_date
from back_office.report_conformity_pu_bu
order by id desc
limit 10;