Equality functions not working for DateTime

[itsjay (Jay)]

When using equality functions where the value is also from a predicate, I get the error:

Got error: parsing time \"UserStatus.createdAt\" as \"2006-01-02T15:04:05\":
 cannot parse \"UserStatus.createdAt\" as \"2006\" while running: name:\"gt\" args:\"UserStatus.createdAt\" ",

The query I’m using:

query {
  g(func: type(UserStatus)) {
    UserStatus.question @filter(gt(Ques.publishedAt, UserStatus.createdAt)) {
      uid
      Ques.name
    }
  }
}

and the schema:

type UserStatus {
  id: ID!
  question: Ques!
  createdAt: DateTime!
}

type Ques {
  id: ID!
  name: String!
  publishedAt: DateTime!
}

These two questions suggest that the DateTime should be in the RFC3339 format, so I tried that but no luck.
UserStatus.createdAt = "2020-11-05T18:08:05.000000786-07:00"

If I replace User.createdAt with the value itself, it works.
For example:
UserStatus.question @filter(gt(Ques.publishedAt, "2020-11-05T18:08:05Z)) {
And it doesn’t even need to be in RFC format.

Datetime query by month error

Hi, I am using version 20.11.3 I want to query the nodes within a certain month I have this index created: datetime @index(month) . The date data I have has this format: “2021-03-11T18:08:28Z” I have this query @filter(eq(created, [“10”])) but i get this error: “message”: ": Got error: parsing time “10” as “2006-01-02T15:04:05”: cannot parse “10” as “2006” while running: name:“eq” args:“10” ", “extensions”: { “code”: “ErrorInvalidRequest”* } I do not have any in my nodes with the y…

Dgraph date.Time

Hello. What correct type I can add to dgraph dateTime type? When I use the official example， ran into the following problem status = StatusCode.UNKNOWN details = "parsing time “” as “2006-01-02T15:04:05”: cannot parse “” as “2006"” schema: public_date: datetime . implementation_date: datetime . item = { ‘public_date’: datetime.datetime(1980, 1, 1, 23, 0, 0).isoformat(), ‘implementation_date’: datetime.datetime(1981, 1, 1, 23, 0, 0).isoformat(), } Did I do something wrong?

Is this a known issue?

[MichelDiz]

@itsjay

@filter(gt(Ques.publishedAt, UserStatus.createdAt))

What is going on here? I don’t get it. You are using two predicates as params or is that a typo in your question?

[itsjay (Jay)]

Is that wrong? I figured since both preds are of type Datetime, I could just use it like that.

Basically, what I want to do is get a question where Ques.publishedAt > UserStatus.createdAt.

[MichelDiz]

@itsjay

Is that wrong?

Yes. It is. You should user variables instead.

Something like this(not precise)

 {
  var(func: type(UserStatus)) {
    DT as createdAt
  }
  g(func: type(Ques)) @filter(gt(Ques.publishedAt, val(DT))) {
    id
    name
  }
}

[itsjay (Jay)]

So I had something like that and it wasn’t working. I just realized i wasn’t doing val(), just comparing it to DT.

Thank you for your help. Appreciate it

[itsjay (Jay)]

Also… I feel like the error message can be improved.