Graphql-engine: Working with Postgres dates and times in queries

Created on 26 Oct 2019 · 5Comments · Source: hasura/graphql-engine

Is there any documentation on what Postgres operators are available when querying/setting dates/times? It's awesome that I can make a query like this (note the now() in where and _set):

 mutation ConfirmEmail($token: String!) {
        update_email_confirmation(
          where: { token: { _eq: $token }, created_at: { _lt: "now()" } }
          _set: { confirmed_at: "now()" }
        ) {
          returning {
            email_confirmation_id
            email
            created_at
            confirmed_at
          }
        }
      }

I'd love to be able to subtract 30 days from the now() in the where clause, e.g.:

 mutation ConfirmEmail($token: String!) {
        update_email_confirmation(
          where: { token: { _eq: $token }, created_at: { _gt: "now() - interval '29' day" } }
          _set: { confirmed_at: "now()" }
        ) {
          returning {
            email_confirmation_id
            email
            created_at
            confirmed_at
          }
        }
      }

But I'm missing something, or this isn't yet supported:

{
  "errors": [
    {
      "extensions": {
        "path": "$",
        "code": "data-exception"
      },
      "message": "invalid input syntax for type timestamp with time zone: \"now() - interval '29' day\""
    }
  ]
}

Anyone have any hints on how I can query for something "within the past 30 days"?

duplicate question

Source