Re: [asterisk-users] Mysql 6 second rounding

Mon, 13 Nov 2006 12:34:51 -0800

Supposing you have an extra column called 6second:

UPDATE cdr SET 6second=billsec+(6-mod(billsec,6) where 6second=0

if you want a decimal minutes column called billmin

UPDATE cdr SET billmin=round((billsec/60)+0.5),1) where billmin=0


Vicky wrote:
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 <[EMAIL PROTECTED]> wrote:
sum(duration+(6-mod(duration,6) for summary of seconds divisible by 6,  /60 for minutes

_______________________________________________
--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

Reply via email to