Extraer info de la tabla CDR convirtiendo duration

mcfee

Joined
Oct 28, 2008
Messages
141
Likes
0
Points
16
#1
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....
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,902
Messages
130,886
Members
17,563
Latest member
dineshr
Top