无法展示数据库指定日期区间内的数据，求解决方案

我需要从数据库中筛选出满足**kalkis_tarih（出发日期） ≤ 当前时间 < varis_tarih（到达日期）**的数据行，之前试过多种方法都没成功，包括使用错误的BETWEEN-INTERVAL语句：

BETWEEN kalkis_tarih - INTERVAL varis_tarih

也尝试过if()函数和网上找到的其他方案，均未解决问题。

另外，也想了解如何简便筛选出该日期区间之前和之后的数据。

以下是我的PHP查询代码：

<?php
        foreach (cok("SELECT * FROM seferler INNER JOIN crew ON crew.crew_id=seferler.kaptan_id INNER JOIN filo ON filo.filo_id=seferler.arac_id INNER JOIN duraklar ON duraklar.id=seferler.kalkis AND seferler.varis ORDER BY kalkis_tarih LIMIT 20") as $key => $sefer): ?>
          <tr>
              <th scope="row text-center">&nbsp;&nbsp;&nbsp;&nbsp;<?= date_format(date_create($sefer['kalkis_tarih']),"d/m/y") ?><br><?= date_format(date_create($sefer['kalkis_tarih']),"h:i") ?> - <?= date_format(date_create($sefer['varis_tarih']),"h:i") ?></th>
              <td><?php foreach(cok("SELECT durak FROM duraklar WHERE id={$sefer['kalkis']}") as $key => $kalkis): ?><?= $kalkis['durak'] ?><?php endforeach ?> | <?= date_format(date_create($sefer['kalkis_tarih']),"d/m - h:i") ?> </td>
              <td><?php foreach(cok("SELECT durak FROM duraklar WHERE id={$sefer['varis']}") as $key => $varis): ?><?= $varis['durak'] ?><?php endforeach ?> | <?= date_format(date_create($sefer['varis_tarih']),"d/m - h:i") ?></td>
              <td><?= $sefer['crew_name'] ?></td>
              <td><?= $sefer['filo_name'] ?></td>
              <td><i class="fa-solid fa-circle-info"></i></td>
          </tr>
<?php endforeach; ?>

内容的提问来源于stack exchange，提问作者emre tarhan