Extraer info de la tabla CDR convirtiendo duration

Discussion in 'Elastix 2.x' started by mcfee, Dec 22, 2009.

  1. mcfee

    Joined:
    Oct 28, 2008
    Messages:
    141
    Likes Received:
    0
    hola amigos


    tengo la siguiente información desde la tabla cdr a travez de una consulta sql


    +---------------------+------------+---------------+----------+
    | calldate | src | dst | duration |
    +---------------------+------------+---------------+----------+
    | 2009-09-14 16:21:14 | 4881414 | 94379989 | 2137486 |
    | 2009-09-28 10:50:15 | 5117 | 5140 | 947745 |
    | 2009-10-29 14:53:55 | 5143 | 5121 | 721288 |
    | 2009-10-29 16:16:12 | 4881414 | 93161739 | 716351 |
    | 2009-01-05 16:21:55 | 4881414 | 98862727 | 108181 |
    | 2009-11-13 15:17:59 | 4881414 | 96855555 | 43922 |
    | 2009-02-10 15:52:45 | 2005 | 730 | 38237 |


    La pregunta es, como hago para que los datos de el campo duration, me los muestre en minutos?


    Gracias a todos....
     

Share This Page