Instead of using the time2str routines that go through timezone conversion in kamailio, let MySQL do it. This helps with the sipcapture module in case the system time is CET but the database is operated in UTC. In these cases the micro_ts and date columns would be offseted by the timezone difference and look-ups fail to work. You can view, comment on, or merge this pull request online at:
https://github.com/kamailio/kamailio/pull/957
-- Commit Summary --
* db_mysql: Let the database convert the timestamp
-- File Changes --
M src/modules/db_mysql/km_val.c (18)
-- Patch Links --
https://github.com/kamailio/kamailio/pull/957.patch https://github.com/kamailio/kamailio/pull/957.diff