Database
[{"DateTime":ISODate("2022-06-30T00:00:00.000Z")},{"DateTime":ISODate("2022-06-30T09:00:00.000Z")}]
Query
db.collection.aggregate([{$match:{$expr:{$and:[{$gte:[{"$dateToString":{"date":"$DateTime","format":"%H:%M:%S"}},"08:30:00"]},{$lte:[{"$dateToString":{"date":"$DateTime","format":"%H:%M:%S"}},"18:30:00"]}]}}}])