datediff alternative

[doobster]

Hello,

I was reading the mysql manual and it appears that datediff was added in 4.1. I'm stuck using 4.0.23 and can anybody help point me in the right direction with an alternative to datediff?

Thanks.

[bastien]

convert to unix timestamp and use some math

[bpat1434]

In query it would be something like:

SELECT UNIX_TIMESTAMP(date1) AS start, UNIX_TIMESTAMP(date2) AS end, DATE_FORMAT('%m/%d/%Y %h:%i', (end-start)) AS difference
FROM `table`

Then, just reference the "difference" value...

~Brett