MySQL Forums
Forum List  »  Newbie

Re: update with if statement
Posted by: Shantanu Oak
Date: July 04, 2005 02:13AM

update cdr set Cost=if(mod(BillSec,6)=0,floor(BillSec/6),ceiling(BillSec/6))

Options: ReplyQuote


Subject
Written By
Posted
July 03, 2005 11:27PM
Re: update with if statement
July 04, 2005 02:13AM


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.