Querying a timestamp data (YY-MM-DAY HH:mm:ss.FFF) through Odata 4 generates an error

Solution Verified - Updated -

Issue

  • JDBC query on a timestamp attribute with the format (YY-MM-DAY HH:mm:ss.FFF) succeeds, but generates an error using Odata 4 :
TEIID16053 Unable to process odata request due to: The value '2017-04-05 14:10:51.59444' is not valid for property 'DateTimeColumn'. 

Environment

  • Red Hat JBoss Data Virtualization (DV) 6
  • Odata v4

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