Command syntax

Description

Return whether a time is between two other times.

By default, this is inclusive of the start time and exclusive of the end time. Use the optArgs left_bound and right_bound to explicitly include (closed) or exclude (open) that endpoint of the range.

Example: Retrieve all the posts that were posted between December 1st, 2013 (inclusive) and December 10th, 2013 (exclusive).

r.table("posts").filter(
    row -> row.g("date").during(r.time(2013, 12, 1, "Z"), r.time(2013, 12, 10, "Z"))
).run(conn);

Example: Retrieve all the posts that were posted between December 1st, 2013 (exclusive) and December 10th, 2013 (inclusive).

r.table("posts").filter(
    row -> row.g("date")
        .during(r.time(2013, 12, 1, "Z"), r.time(2013, 12, 10, "Z"))
        .optArg("left_bound", "open").optArg("right_bound", "closed")
).run(conn);