Details
-
Enhancement
-
Resolution: Done
-
Minor
-
None
-
None
-
Compatibility/Configuration, User Experience
Description
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