<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Supposing you have an extra column called 6second:<br>
<br>
UPDATE cdr SET 6second=billsec+(6-mod(billsec,6) where 6second=0<br>
<br>
if you want a decimal minutes column called billmin<br>
<br>
UPDATE cdr SET billmin=round((billsec/60)+0.5),1) where billmin=0<br>
<br>
<br>
Vicky wrote:
<blockquote
cite="midff95c3730611131151y20af13a9q2300d845d8d0d191@mail.gmail.com"
type="cite">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="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div> sum(duration+(6-mod(duration,6) for summary of seconds
divisible by 6, /60 for minutes<span class="q"><br>
</span></div>
</blockquote>
</div>
</blockquote>
<br>
</body>
</html>