[asterisk-bugs] [Asterisk 0016559]: Duration and Billsec Decimal Place

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16559 
====================================================================== 
Reported By:                cianmaher
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16559
Category:                   Addons/cdr_addon_mysql
Reproducibility:            have not tried
Severity:                   feature
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.2.0 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-01-06 14:22 CST
Last Modified:              2010-01-11 06:17 CST
====================================================================== 
Summary:                    Duration and Billsec Decimal Place
Description: 
My problem at present is I has Sangoma ss7 box, woomera, asterisk1.6.2 and
addons 1.6.2 on a server that is connected to 8 ss7 trunks with other
carriers. I have asterisk writing cdr's to mysql however it appears to
round up always. 

For example:

One of the Carriers reports a call duration of 31.7seconds but we report
it as 33seconds assuming because there is some transit duration of approx
0.4 - 0.5 of a second which brings me to 32.1 or 32.2 but then it is
rounded up to 33.

My questions are:

* Is it possible for asterisk not to round the duration and billsec?
* Is it possible to show duration and billsec with a decimal to show the
true figure?

Thanks in advance

====================================================================== 

---------------------------------------------------------------------- 
 (0116435) snuffy (manager) - 2010-01-11 06:17
 https://issues.asterisk.org/view.php?id=16559#c116435 
---------------------------------------------------------------------- 
I have coded up a '30min job' to allow for cdrs to be logged with
'hrbilltime' or time billed to the millisecond. (Will put it up in next
24hr)

If you are currently using cdr_pgsql as your backend and the 'billsec'
field is 'float' type you may..may get what you want without any patch.
(from reading the code in the module) 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-11 06:17 snuffy         Note Added: 0116435                          
======================================================================