Can I pass a Datetime value to the :for-valid-time [:at ] clause in Datalog? Below is an example:

(xt/q node ['{:find [title xt/id]
              :where [($ :todos [{:title title
                                  :xt/id xt/id}]
                         {:for-valid-time [:at #inst "2023-09-03"]})]}])

(xt/q node ['{:find [title]
              :in [dt]
              :where [($ :todos [{:title title}]
                         {:for-valid-time [:at dt]})]}
            (java.time.Instant/now)])

java.lang.NullPointerException: Cannot invoke "xtdb.vector.IIndirectVector.getVecter()" becuase "col" is null

Hey @U01CNN12HNY I'm not sure on exactly what should be working here currently - but do you get the same result with a more precise #inst literal? e.g. #inst "2023-09-02T16:00:00"? This could equally be an issue with parameterising the :at value (in which case you could work around it with quoting / constructing the query as data)

hi thanks for answering. I've tried parameterizing the Datetime, so I can't use parameterization with :in. Are you suggesting that I construct the query as data? Is that correct?

> Are you suggesting that I construct the query as data? Is that correct? yes, that should unblock you for now, at least

but I'll check with the team about the expected behaviour next week - and potentially open an issue

thanks a lot!

hey again @U01CNN12HNY we just opened an issue to track the resolution on this https://github.com/xtdb/xtdb/issues/2754 - thanks again for flagging it 🙏

wow! good to know! thank you!