Hello,
I'm reading this list for some time and checked the FAQ, archive
but i haven't found any hints ...
I have an own written app which is using a 'kind of database' to
calculate the difference between two (or more) events which can
happen between tens or hundreds of seconds.
Now i want to switch to a real database but i'm unable to
find a database function to calculate the difference between (for
example '2001-03-05- 20:09:10.54' and '2001-03-05 20:11:34.36')
of two events with a 'factional' time.
I've tried something like
INSERT INTO t_start, t_stop VALUES
(UNIX_TIMESTAP(now() + 0.54) , UNIX_TIMESTAMP(now() + 0.38)
but this is not working for a 'DATETIME' field, a 'FLOAT' field
returns 0.
The difference between the two times is very critical because the
app is written for sports events ...
Maybe someone uses MySQL within such an application and has can
provide some hints
Andreas Karl Wittwer
Phone: +49-7052-92206
FAX: +49-7052-92208
Mobil: +49-172-542 541 4
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
