[asterisk-bugs] [Asterisk 0016559]: [patch] 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:                     confirmed
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 17:29 CST
====================================================================== 
Summary:                    [patch] 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

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

---------------------------------------------------------------------- 
 (0116483) tilghman (administrator) - 2010-01-11 17:29
 https://issues.asterisk.org/view.php?id=16559#c116483 
---------------------------------------------------------------------- 
I disagree with your analysis, snuffy.  The adaptive drivers are already
capable of handling multiple decimal places within both duration and
billsec, though the timestamps themselves cannot.  This is available in all
versions from 1.6.0 forward.

However, it appears that the cdr_mysql driver does not handle duration and
billsec this way, although the cdr_pgsql driver does.  Given that it exists
in the cdr_pgsql driver, it can be easily added to the other adaptive CDR
drivers, as well. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-11 17:29 tilghman       Note Added: 0116483                          
======================================================================