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.
Cheers, Daniel On 10/12/2016 07:15, Slava Bendersky wrote: > 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
_______________________________________________ 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
