File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes java.sql.Time capacity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.Time capacity" Watch "java.sql.Time capacity" New topic

java.sql.Time capacity

tun zaw

Joined: Jan 23, 2008
Posts: 22
Please help me.

I use mysql 5.0.45 and jdbc.I have some problem with java.sql.Time capacity.
In command line client,when i use SEC_TO_TIME(SUM(TIME_TO_SEC(duration))) command,although duration is greater than 24:00:00 everything is ok.
But, if time is grater than 24:00:00, there is the following
error in jdbc code.
Illegal Time 24.
What should i do?
Please help me.
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46397
Sorry it took so long to find, but have been busy. MySQL Manual; look for TIMEDIFF.
I agree. Here's the link:
subject: java.sql.Time capacity
It's not a secret anymore!