The use_start_date column in the T_reserve_room table in the database is 2024-06-12 16:18:00
and the use_end_date column is 2024-06-14 19:48:00

This code works

def getReserveSummary():
    reserve = (
        db.session.query(
        .
        .
        .
        )
        .filter(
          and_(
              T_reserve_room.use_start_date >= datetime.datetime(year=2024, month=6, day=12, hour=0, minute=0, second=0),
              T_reserve_room.use_end_date <= datetime.datetime(year=2024, month=6, day=14, hour=23, minute=59, second=59),
          )
        )
        .
        .
        .
    )

    return reserve.one()

but

this doesn’t

def getReserveSummary():
    reserve = (
        db.session.query(
        .
        .
        .
        )
        .filter(
          and_(
              T_reserve_room.use_start_date >= datetime.datetime(year=2024, month=6, day=12, hour=0, minute=0, second=0),
              T_reserve_room.use_end_date <= datetime.datetime(year=2024, month=6, day=12, hour=23, minute=59, second=59),
          )
        )
        .
        .
        .
    )

I don’t know why the second one doesn’t work because both filter much the database. What did I mistake?

I did try to change some database data but nothing change.