<div dir="ltr">Hi,<div><br></div><div>as a workaround you could create a trigger for the before-insert event to modify the new row with the correct values by adding or subtracting hours depending on your timezone.</div><div>
<br></div><div>Regards,</div><div>Carlos</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Nov 14, 2013 at 11:37 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    Hello,<br>
    <br>
    upcoming release 4.1 has more options to control the time value in
    acc table. See time_mode parameter and the next after it:<br>
    <br>
<a href="http://kamailio.org/docs/modules/devel/modules/acc.html#acc.p.time_mode" target="_blank">http://kamailio.org/docs/modules/devel/modules/acc.html#acc.p.time_mode</a><br>
    <br>
    Otherwise, you can set the timezone to gmt.<br>
    <br>
    Cheers,<br>
    Daniel<div><div class="h5"><br>
    <br>
    <div>On 11/14/13 2:55 PM, Igor Potjevlesch
      wrote:<br>
    </div>
    </div></div><blockquote type="cite"><div><div class="h5">
      
      
      
      <div>
        <p class="MsoNormal"><span lang="EN-GB">Hi,<u></u><u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB">I’m wondering how can I
            change the timezone when INVITE, ACK, BYE and CANCEL are
            inserted into acc table? Indeed, today, each entrie has the
            same datetime than the server. I would prefer to have UTC
            time in “time” column instead.<u></u><u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB">I know that it was the
            behaviour with old SER releases. <u></u><u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB">Thank for your help.<u></u><u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB">Regards,<u></u><u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span lang="EN-GB">Igor.<u></u><u></u></span></p>
      </div>
      <br>
      <br>
      <hr style="border:none;color:#909090;background-color:#b0b0b0;min-height:1px;width:99%">
      <table style="border-collapse:collapse;border:none">
        <tbody>
          <tr>
            <td style="border:none;padding:0px 15px 0px 8px"> <a href="http://www.avast.com/" target="_blank"> <img border="0"> </a> </td>
            <td>
              <p style="color:#3d4d5a;font-family:"Calibri","Verdana","Arial","Helvetica";font-size:12pt"> Ce courrier électronique ne contient
                aucun virus ou logiciel malveillant parce que la
                protection <a href="http://www.avast.com/" target="_blank">Antivirus avast!</a> est
                active. </p>
            </td>
          </tr>
        </tbody>
      </table>
      <br>
      <br>
      <fieldset></fieldset>
      <br>
      </div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
    </font></span></blockquote><span class="HOEnZb"><font color="#888888">
    <br>
    <pre cols="72">-- 
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Trainings - Berlin, Nov 25-28
  - more details about Kamailio trainings at <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a> -
</pre>
  </font></span></div>

<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Carlos<div><a href="http://caruizdiaz.com" target="_blank">http://caruizdiaz.com</a></div><div>+595981146623</div>
</div>