Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Setting parameter for datetime in SQL Stored Procedure

843853Aug 15 2001 — edited Aug 16 2001
I have a stored procedure with datetime parameter. But when I use CallableStatement to set parameter, I can only find setTimestamp. In fact, I can execute the Stored Procedure successfully, but I find the value in the result table is stored without 'seconds'.

For example:
passed value: "2001-8-15 09:12:45.000"
stored value: "2001-8-15 09:12:00" (datetime)

What happened? Hope someone may help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2001
Added on Aug 15 2001
#java-database-connectivity-jdbc
4 comments
171 views