MySQL Forums
Forum List  »  Oracle

mysql queries
Posted by: alka pandey
Date: February 11, 2012 12:10PM

hello...
i have made a database in which there are fields named kmin,kmout,datein,dateout,mttr,and mkbf.
i have to calculate mttr and mkbf using kmin,kmout,datein and dateout.
this is formula-mttr=(kmout-kmin)/(dateout-datein)
is there any sql query which we can use to calculate this along witn insert mttr and mkbf in database for further use.
plzz help
thanks
alka pandey
student

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql queries
3348
February 11, 2012 12:10PM
1777
February 14, 2012 07:16PM
1897
February 17, 2012 10:19AM


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.