Thx and what would the sql query be ? . I plan to put additional field as 6second . <br>How can i make billsec of values of whole table get rounded and filled in field "6second"<br> Sorry i am a noob with mysql :D
<br><br><div><span class="gmail_quote">On 14/11/06, <b class="gmail_sendername">James Coberly</b> <<a href="mailto:james.coberly@xmc.com">james.coberly@xmc.com</a>> wrote:</span><blockquote class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom: 0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
<div> sum(duration+(6-mod(duration,6) for summary of seconds divisible by 6, /60 for minutes<span class="q"><br><br><br> On Tue, 2006-11-14 at 00:07 +0530, Vicky wrote:<br></span><blockquote type="CITE"><span class="q"><font color="#000000">
This is more of mysql question then asterisk :D . Most voip providers use 6 second rounding for costing . My asterisk server stores call cdr's in mysql properly with billsec field containing number of billed seconds . I want to know some function to round this to 6 seconds ( or any custom valud like 30 seconds ) ..Suppose if billsec field is 3 seconds then it should round to 6 seconds , if its 13 second then it should round up to 18 seconds ( for 6sec pulse counting ) . What would be mysql function to do this ?
</font><br><font color="#000000"> </font> </span><pre><font color="#000000">_______________________________________________</font> <font color="#000000">--Bandwidth and Colocation provided by <a href="http://Easynews.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
Easynews.com</a> --</font><font color="#000000">asterisk-users mailing list</font> <font color="#000000">To UNSUBSCRIBE or update options visit:</font> <font color="#000000"> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://lists.digium.com/mailman/listinfo/asterisk-users</a></font> </pre></blockquote></div><br>_______________________________________________<br>--Bandwidth and Colocation provided by <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://Easynews.com" target="_blank">
Easynews.com</a> --<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">
http://lists.digium.com/mailman/listinfo/asterisk-users</a><br><br><br></blockquote></div><br>