Is it possible to get current time in dgraph query?

Users Dgraph
1

I need to write query to retrieve data that are created one day ago. From example: https://docs.dgraph.io/query-language/#inequality, so below query will retrieve “Ridley Scott movies released after 2018-05-06”. I need “2018-05-06” datetime to be dynamic. So whenever i request query it should get yesterdays date and compare with data. How can i do it?

{
  me(func: eq(name@en, "Ridley Scott")) {
    name@en
    director.film @filter(gt(initial_release_date, "2018-05-06"))  {  #I need here yesterdays date.
      initial_release_date
      name@en
    }
  }
}

@pawan, @MichelDiz need help…

2

You can use ‘eq’. About yesterday’s date, this you set via your application’s logic - Your application needs to know what day is “today” and send the yesterday date to Dgraph. But about the range, I think you can use AND to create a range of the day if putting the short date does not solve.

https://docs.dgraph.io/query-language/#and-or-and-not

{
  me(func: eq(name@en, "Ridley Scott")) {
    name@en
    director.film @filter(eq(initial_release_date, "1977-12-01"))  {
      initial_release_date
      name@en
    }
  }
}