[asterisk-users] Mysql 6 second rounding

James Coberly james.coberly at xmc.com
Mon Nov 13 11:58:20 MST 2006


sum(duration+(6-mod(duration,6) for summary of seconds divisible by
6,  /60 for minutes


On Tue, 2006-11-14 at 00:07 +0530, Vicky wrote:

> 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 ? 
>  
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20061113/befd1b44/attachment.htm


More information about the asterisk-users mailing list