[teiid-issues] [JBoss JIRA] (TEIID-4110) Odata - date functions does't accept date string as a parameter

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254523#comment-13254523 ] 

RH Bugzilla Integration commented on TEIID-4110:
------------------------------------------------

Juraj Duráni <jdurani at redhat.com> changed the Status of [bug 1322536|https://bugzilla.redhat.com/show_bug.cgi?id=1322536] from ON_QA to VERIFIED

> Odata - date functions does't accept date string as a parameter
> ---------------------------------------------------------------
>
>                 Key: TEIID-4110
>                 URL: https://issues.jboss.org/browse/TEIID-4110
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: OData
>            Reporter: Michal Sanitrak
>            Assignee: Ramesh Reddy
>             Fix For: 9.0, 8.12.5
>
>
> Date functions year, month, day, hour, minute and second doesn't accept date string(DateTimeOffset) as a parameter.
> Reference service which supports OData V4:
> *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=month(2001-01-01T00:01:01.01Z) eq EmployeeID 
> *Result:* Employee with ID 1
> *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter=month(2001-01-01T00:01:01.01Z) eq intkey
> *Result:* {"error": {"code": null, "message": "TEIID30069 The function 'MONTH(?)' has more than one possible signature." }}
> *Expected result:* Entity with intkey 1



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)