[asterisk-users] Mysql 6 second rounding

[Vicky]

Thx and what would the sql query be
? . I plan to put additional field as 6second .
How can i make billsec of values of whole table get rounded and filled
in field "6second"
Sorry i am a noob with mysql :D

On 14/11/06, James Coberly <james.coberly at xmc.com> wrote:
>
> 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
>
>
> _______________________________________________
> --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/ce1d189e/attachment.htm