Back to top

    ReQL command: date

    Command syntax

    time.date() → time

    Description

    Return a new time object only based on the day, month and year (ie. the same day at 00:00).

    Example: Retrieve all the users whose birthday is today.

    r.table("users").filter(lambda user:
        user["birthdate"].date() == r.now().date()
    ).run(conn)
    

    Note that the now command always returns UTC time, so the comparison may fail if user["birthdate"] isn’t also in UTC. You can use the in_timezone command to adjust for this:

    r.table("users").filter(lambda user:
        user["birthdate"].date() == r.now().in_timezone("-08:00").date()
    ).run(conn)
    

    Get more help

    Couldn't find what you were looking for?