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!

DATETIME Granularity - with PreparedStatement.setDate()

843859Aug 4 2005 — edited Aug 5 2005

Hi-ya

I have defined a column as DATETIME, in my program I call the method setDate from the class PreparedStatement and pass a normal date object.

Now a date object in java has granularity down well past the milisecond, but when I execute this statement in my table I only see a date and no time.

This is actually what I am seeing (from PhPAdmin) 2005-08-05 00:00:00, maybe this is a bug from PhPAdmin but I doubt it.

What has happened to the time? Should I be calling another method?

thanks

kent

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2005

Added on Aug 4 2005

#java-database-connectivity-jdbc

5 comments

262 views