Subtraction of two dates in OData query
I am exposing a table thru an OData feed based on WCF Data Services
(version 5.6.0) with two dates in it - StartDate and EndDate. I would like
to query my data for rows where e.g. the difference (TimeSpan) between the
two dates is more than two hours.
Is this at all possible?
Naturally I could do it in T-SQL and also in LINQ, but I am missing the
link (no pun intended) to doing it across the OData query layer.
Can you guys help? I'd much rather do it directly in the ODate query than
defining a service operation to perform the task.
Thanks,
/Jesper
Copenhagen, Denmark
No comments:
Post a Comment