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.
posted 8 years ago
Sorry it took so long to find, but have been busy. MySQL Manual; look for TIMEDIFF.