I have a table that contains two datetime columns, and I need to determine
the time between the two dates. So, what I've been doing is just
subtracting what I know is the later date from the earlier date. But that's
obviously not the way to do it as my results don't relate to anything.
Here's what my data looks like:
Datetime_A Datetime_B (Datetime_A - Datetime_B)
2001-02-20 14:09:38 2001-02-20 14:20:43 18.416666666667
2001-02-20 14:14:45 2001-02-20 14:30:35 26.5
2001-02-20 14:22:03 2001-02-20 14:28:14 10.183333333333
The differences should be 11 minutes 5 seconds, 15 minutes 50 seconds and 6
minutes 11 seconds respectively - but that's not what I'm getting. As I'm
obviously doing this wrong, what is the correct means of determining the
time difference between two datetime fields? Thanks in advance,
Dunc.
---------------------------------------------------------------------
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
