OData Passing a DateTime URL Parameter error in DV

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.