Hello,

i'm trying to get the difference between 2 datetime fields, but MySQL seems to work wrong on this. In my case i'd like to get the difference between 08:59am and 09:01am for example. I tried it within a query like "select sum(stop-start) as diff from times where ..." but this doesnt work and the result is more than i expected. Does anybody know how to substitude one datetime field from another.

Thx
Begar

I'd use the TIMESTAMPDIFF function.

-PatP

you would

but i wouldn't, because it's only in version 5.0

last time i looked, 4.1 was still in beta, and 5.0 was in alpha

i.e. very unreliable

instead, i would calculate the difference in seconds like this:

select UNIX_TIMESTAMP(stop)-UNIX_TIMESTAMP(start)

then i might use FROM_UNIXTIME() if i knew the difference was gonna be more than a day, and maybe SEC_TO_TIME() if less

but in my case UNIX_TIMESTAMP of my Datetime field is always 0. Does anybody have an Idea why ist is always 0?

Another Problem is, that i m working with Access and when i m using Mysql-functions i get an error that Access cant work with these functions.

Any Idea?
Begar

possibly because it's null, possibly because it's not a valid datetime value

the reason for this is because access does not support mysql functions