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.