OData Passing a DateTime URL Parameter error in DV
Issue
- We are having an issue when trying to pass a date time parameter in an OData URI. We are using a datetime function as part of the URI to create a datetime object. The query string that we pass on the URI is as follows:
?user_id=2L&from_date=datetime'2012-01-25T01:01:01'&to_date=datetime'2014-01-24T01:01:01'
This results in the following error:
TEIID30558 Error converting parameter number 2 with value "25/01/12 01:01" to expected type date.
- What is the proper syntax?
Environment
- Red Hat JBoss Data Virtualization (DV) 6.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.