[Asterisk-Users] CDR Output

[Karl Putland]

On Tue, 2003-03-04 at 11:57, Matthew S. Hill wrote:
> I am pushing all the cdr info to a MySQL database on a separate machine. 
> I have noticed that the duration times for all calls are recorded in 
> seconds, by Asterisk. Is there a way to set the recorded call duration 
> to a decimal representation of minutes? ie 90 sec = 1.5 min. My 
> extraction process would be a little simpler if the data dumped into the 
> database were minutes and not seconds.
> 

Write a trigger for on insert or a view that converts sec->min.  Oh wait
your using MySQL.  Use PostgreSQL ;)


-- 
Karl Putland <karl at putland.linux-site.net>