I am using JDBC Adapter 22.214.171.124 with FIX14 on wm 6.5. I noticed a problem with JDBC Adapter. I am querying DATE fields from Oracle database. In the dyanmic SQL template I selected the output type for these date fields are strings. I can not select ‘java.util.Date’ as the output format for this field, because this adapter service is also used to query other tables and this implementation can not be changed now. I have observed that I am getting different values at different times.
- Few times I get the date value in format yyyy-MM-dd.
- Few times I get the date value in format yyyyMMdd.
I checked with my client if he changed the date format in the table. He said ‘no’. What is the fix for it? Anything went wrong here?