MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Calculate Time difference as decimal fraction
Posted by: David Smith
Date: July 07, 2005 12:47AM

Hello. I have a table with 2 time values start_time and end_time and a date value of trans_date. I need to run a query to give me hours_worked there may be a case also where an employee can work beyond midnight. Any help with this please.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Calculate Time difference as decimal fraction
David Smith
July 07, 2005 12:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.