See https://service.mendixcloud.com/p/OQL for the oql-playground. To see your requested date example click on button “Where Date < $DateTimeParameter”:
and you will see a guide how to pass the date parameter.
*****Editted*****
I still don't understand the clear difference and usage of oql and sql.
Is there a place where I can see a more detailed and kind explanation?
thank you~