Calculate difference in time dialplan func_odbc or mysql

i know i am late but its always better to post answer if you know…:smile:

exten = _X.,n,Set(callstarttime=${STRFTIME(${EPOCH},%Y%m%d)}${STRFTIME(${EPOCH},%H%M%S)})
exten = _X.,n,Set(callendtime=${STRFTIME(${EPOCH},%Y%m%d)}${STRFTIME(${EPOCH},%H%M%S)})
exten =_X.,n,Set(diff1=$[${calltime1} -${calltime}])
exten=_X.,n,NoOp(diff1)

Cheers,
Pratap Thakur