inquisitive123
asked on
jdbc driver date format conversion - type 4 jdbc driver and oracle 9i
Hi,
I work with oracle 9.0.1 server and jdbc driver from Oracle(classes12.zip/jar). From the scripting environment, if I try to insert a date field from a string with to_date('2004/10/06 10:21:00','yyyy/mm/dd hh24:mi:ss'), looks like the type 4 jdbc driver does some additional conversion and the oracle database server receives somes distorted input.
Is there any way, I can disable the jdbc driver conversion or to handle this situation better through default config like nls_date_format settings?
Thanks
I work with oracle 9.0.1 server and jdbc driver from Oracle(classes12.zip/jar).
Is there any way, I can disable the jdbc driver conversion or to handle this situation better through default config like nls_date_format settings?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.