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{ |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{ |user|
    user["birthdate"].date() == r.now().in_timezone("-08:00").date()
}.run(conn)

Get more help

Couldn't find what you were looking for?