---

where atc."date" >=
    case
        when :start_date_app = 'now()' then current_date
        when :start_date_app = 'now() - interval 24 hours' then current_date - interval '1 day'
        else to_date(:start_date_app, 'YYYY.MM.DD')
    end
  and atc."date" <
    case
        when :end_date_app = 'now()' then current_date
        when :end_date_app = 'now() - interval 24 hours' then current_date - interval '1 day'
        else to_date(:end_date_app, 'YYYY.MM.DD')
    end + interval '1 day'