JDBC Adapter TIMESTAMP dataType Conversion

Hi community,

We are using wm9.7, JDBC Adapter 9.0 For JDBC Fix 8. Oracle DB we are using in 9i.
i get only “07/05/2016” instead of “07/05/2016 XX:XX:XX” when I created a normal select adapter service, since there is no option of selecting JDBC datatype as “TIMESTAMP” i just have “DATE”.

should we have to do some configuration changes or patches for wm9.7 to resolve this?

Alternatively when i created a customSQL Adapter Service with the output field defined as TIMESTAMP, I was able to get the date and time stamp as desired.

thanks for the help in advance.

select java.lang.string or setAsString instead of TimeStamp. Check if that works.