|
Hi Markus,
You could create a derived attribute in your model for the truncated value, but it would calculate that every time you fetch rows as well.
Ramsey
No one?
I can live with raw rows but would have been great if anyone knows
---markus---
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
4051 Basel / Switzerland
mobile +41
79 508 4701
Confidentiality Notice: This email, including all attachments and replies thereto, are covered by the Electronic Communications Privacy Act, 18 U.S.C. Sections 2510-2521 and are legally privileged. This information is confidential, and intended only
for the use of the individuals or entities named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of this transmitted information is strictly
prohibited. Please notify us if you have received this transmission in error. Thank you.
|