Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5311

Sybase implicit Convertion of String value 'yyyy-MM-dd HH:mm' into a Date value Causes mismatches in JDV Date comparison

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Minor Minor
    • 11.2
    • None
    • Query Engine
    • None
    • Compatibility/Configuration, User Experience

      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

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-asaji Anu Saji
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: