Select date via datepicker

Question

Devs blz?

In my form I need to include a field to select date, I want to use a bootstrap datepicker or similar. It is a scheduling system where I make a query to the database to return the available times for the selected day.

The point is I’m doing this consultation with select... My question is how I can put a calendar in the select entry to do this query, so I know I can only call a calendar with input type='data'

    <label class="label">
    <span>Selecione um dia:</span>
    <select name="appointment_schedule_id" class="horarios">
        <option selected disabled value="">Nenhum Selecionado</option>
        <?php
        $read->readFull("SELECT 

                            *
        
                            FROM schedule s 
                            WHERE s.schedule_status IS NULL 
                                AND s.schedule_tstamp >= CURRENT_TIMESTAMP 
                            GROUP BY s.schedule_ref
                            ORDER BY s.schedule_tstamp ASC");
                            

        $schedules = ($read->getResult() ? $read->getResult() : null);

        if (!empty($schedules)) {
            foreach ($schedules as $schedule) {
                $schedule = (object) $schedule;
                echo "<option value='{$schedule->schedule_id}'>" . date('d/m/Y', strtotime($schedule->schedule_tstamp)) . "</option>";
            }
        }
        ?>
    </select>
</label>

I do not know if I understand, summarizing I need that in the select of the code above when clicking can be opening a calendar so that I can choose date for scheduling.