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 <[EMAIL PROTECTED]> _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
