search

sipcapture / homer-api

HOMER 5: Back-End (API) DEPRICATED - use sipcapture/homer-app
http://sipcapture.org
27 stars 67 forks source link

PostgreSQL kamailio.cfg timestamp issue again #114

Closed dpocock closed 8 years ago

dpocock commented 8 years ago

It looks like the column types changed in the latest schema, so these need to replace the earlier fix:

    #$var(t_date) = "to_char(date(to_timestamp(" + $var(t1) + ")), '%Y-%m-%d %H:%i:00')";
    $var(t_date) = "to_timestamp(" + $var(t1) + ")";

    #$var(f_date) = "to_char(date(to_timestamp(" + $var(t2) + ")), '%Y-%m-%d %H:%i:00')";
    $var(f_date) = "to_timestamp(" + $var(t2) + ")";
adubovikov commented 8 years ago

https://github.com/sipcapture/homer-api/commit/f1ae5e0b9aec7efc5677ab80140714e651d63563