Hello,

it is the timestamp value (the value of time(NULL) C function), there should different functions that can be used for converting it to local datetime or utc.

Hello Everyone,

What format stored inc_time in msilo module ?  I am trying convert it to human readable format, but time looks UTC

SELECT FROM_UNIXTIME($(xavp(dbquery[$var(i)]=>inc_time)), '%M %D %Y %h:%i:%s')

Slava.

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com