On 1 Nov 2021, at 12:54, Markus Ruggiero (rucotec) <webobjects-dev@wocommunity.org> wrote:

Need to find objects satisfying the following condition:

CHECK_IN_TIME must be at least on the same day or later than REQUESTED. Both values are stored as NSTimestamp with a 15 minutes precision.

In Postgres I would write

...where date_trunc('day', CHECK_IN_TIME) >= date_trunc('day', REQUESTED)

How can I create a qualifier for this? Is this possible at all or do I have to resort to raw rows for SQL?

Thanks

---markus---

Markus Ruggiero

rucotec GmbH                        web https://rucotec.ch

Steinenvorstadt 79                email markus.ruggiero@rucotec.ch

4051 Basel / Switzerland         mobile +41 79 508 4701