I have a base view and an interface for the base view. In both the base view and interface one of the columns, ReportingDate, is defined as a timestamp. Using ODATA, I am able to invoke the endpoint and get back results. I can also add a filter condition to other columns and the data is returned correctly.
But, when I pass a value for the ReportingDate, I am getting an Oracle exception.
Here is my filter condition:
$filter=ReportingDate gt 2010-01-01T23:01:00Z
Here is the exception that is returned:
Received exception with message 'ORA-01861: literal does not match format string' Received exception with message 'ORA-01861: literal does not match format string'\n ; nested exception is java.sql.SQLException: Error executing query. Total time 0.36 seconds
I have other interfaces/base views that are working and I can pass a timestamp parameter with no issues. So, I am not sure why this exception is thrown. Both the interface and base view define LastRunDate as a timestamp.
This works for another endpoint:
$filter=LastRunDate eq 2017-05-02T21:02:09Z