[teiid-issues] [JBoss JIRA] (TEIID-5311) Sybase implicitly Convertion of String value 'yyyy-MM-dd HH:mm' into a Date value Causes mismatches in JDV Date comparison

Anu Saji created TEIID-5311: ------------------------------- Summary: Sybase implicitly Convertion of String value 'yyyy-MM-dd HH:mm' into a Date value Causes mismatches in JDV Date comparison Key: TEIID-5311 URL: https://issues.jboss.org/browse/TEIID-5311 Project: Teiid Issue Type: Enhancement Components: JDBC Connector, Query Engine Reporter: Anu Saji Assignee: Steven Hawkins Priority: Minor Fix For: 10.x Sybase implicitly converts a String value 'yyyy-MM-dd HH:mm' into a Date value. This format is not standard and this conversion is specific to Sybase. As JDBC/Java standard, JDV implicitly converts 'yyyy-MM-dd HH:mm:ss' into a Timestamp value 'yyyy-MM-dd' into a Date value So JDV does not considered 'yyyy-MM-dd HH:mm' as a Date value and does not proceed to any implicit conversion. 'yyyy-MM-dd HH:mm' remains like a String value which partially matches with Date comparison Constraint We cannot modify the incoming query -- This message was sent by Atlassian JIRA (v7.5.0#75005)