I am working on a project that needs to get
This particular format 1000.25
1000 representing hours and 25 represent minutes
1000 means a full 1000 minutes
.25 means a quarter of an hour
so essentially in english language we could say a thousand hours and about 15
minutes
I need a way in sql or simple programming to take a timpestamp(end time) and a
timestamp(beginning time)
for instance 12:00:00 is the end time
11:30:44 is the start time
from here is where i need a solution that gets me the difference of these two
times in a decimal format. Of course once I get that I may need to convert
back in english to say there are 30 minutes and 44 seconds.
any ideas
---------------------------------------------------------------------
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
