]
Ramesh Reddy resolved TEIID-4247.
---------------------------------
Resolution: Done
OData - support date and time functions
---------------------------------------
Key: TEIID-4247
URL:
https://issues.jboss.org/browse/TEIID-4247
Project: Teiid
Issue Type: Feature Request
Components: OData
Affects Versions: 8.12.x
Reporter: Andrej Šmigala
Assignee: Ramesh Reddy
Fix For: 9.1
The functions date() and time() are currently not supported in odata queries, e.g.
running query
{noformat}http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable?$filter=timeval%20gt%20time(now()){noformat}
returns {code:xml}
<?xml version='1.0' encoding='UTF-8'?>
<error
xmlns="http://docs.oasis-open.org/odata/ns/metadata">
<code>TEIID16027</code>
<message>TEIID16027 Function time is not currently supported </message>
</error>
{code}
This is allowed behaviour per the [odata
spec|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/par...],
but it would be good to have these functions implemented.