Paul Hazlett wrote:

Hi All.

So just to be clear, the timestamp column is the MySQL server local time. Whereas the time column is what exactly??? UTC, GMT, etc??

By default I think the time column is GMT, but that was pretty much useless to us. This also depends on how you configured your servers TIMEZONE. If you did not set any timezone then you would not have this problem.

Regards, Paul

On 8/11/05, Andres andres@telesip.net wrote:

...

TCCHAN wrote:

...

Hi All,

I have acc module to generate cdr for calls.

I noticed that all the calls are timed 4 hour different than what is shown on the real time clock.

Can anyone help?

Thanks for any help available.

Change acc_mod.c so that it uses your local time (change the below variable from 0 to 1):

int db_localtime = 1;

...

Regards,

TC Chan

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers