I'm working with Hibernate 3.0.5 and Mysql 5.0, I have the next problem, I'm trying of get the diff of two timestamp:

select sum(d.firstTimestamp - d.secondTimestamp) from dates d where d.user.id = ? and d.secondTimestamp >= ? and s.firstTimestamp < ? and s.secondTimestamp is not null;

The error:

Hibernate operation: could not execute query; SQL state [S1009]; error code [0]; Cannot convert value '70161.0' from column 1 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '70161.0' from column 1 to TIMESTAMP.
java.sql.SQLException: Cannot convert value '70161.0' from column 1 to TIMESTAMP.

Thanks for you help.

70161.0, a value in one of your columns, isn't matching what hibernate expects a java.sql.Timestamp value to be

Thanks for you help, but the problem is that I do not know like use datediff in hql for mysql. The query work in postgres but not in mysql.


select sum(d.firstTimestamp - d.secondTimestamp) from dates d where d.user.id = ? and d.secondTimestamp >= ? and s.firstTimestamp < ? and s.secondTimestamp is not null;