On Tue, 14 Nov 2006, 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 ?
mysql> select floor(((3 + 5) / 6)) * 6; +--------------------------+ | floor(((3 + 5) / 6)) * 6 | +--------------------------+ | 6 | +--------------------------+ 1 row in set (0.00 sec) mysql> select floor(((13 + 5) / 6)) * 6; +---------------------------+ | floor(((13 + 5) / 6)) * 6 | +---------------------------+ | 18 | +---------------------------+ 1 row in set (0.00 sec) Thanks in advance, ------------------------------------------------------------------------ Steve Edwards [EMAIL PROTECTED] Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000 _______________________________________________ --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
