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(function(user) {
    return user("birthdate").date().eq(r.now().date())
}).run(conn, callback)

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 inTimezone command to adjust for this:

r.table("users").filter(function(user) {
    return user("birthdate").date().eq(r.now().inTimezone("-08:00").date())
}).run(conn, callback)

Get more help

Couldn't find what you were looking for?