What is the easiest way to compute a weekday value of a datetime column in an entity filter? I can’t find such a function in the list of functions.
There is no built-in function so far. But you can create a custom database function.
I would disagree a little.
There is exslt.org dates and times extension implemented into Origam XSLT transformation engine. You can easily use function date:day-in-week(). Check exslt.org for detailed description.
Notice, that first day in a week in this function is Sunday.
Good point. Nevertheless, this is only valid for XSLT transformations. I think the original question was about modeling entity filters (resulting in a pure SQL statements, so no XPath).