Re: [Serusers] Problem with time of call invite in Mysql - sr-users

20 Feb 2006

Hi,

Thanks for the reply.

I can chage my TimeZone but many Users will be having many timezones and if
calls of each and every user records in Mysql DB according to his 
timezone then
how can we have a common timezone for all atleast for getting time 
records in a
particular period for billing.

Manoj.

...
  Quoting Andrey Kouprianov
&lt;andrey.kouprianov(a)gmail.com&gt;om>:

  Change your timezone

 On 2/20/06, mkumar(a)mantragroup.com &lt;mkumar(a)mantragroup.com&gt; wrote:
  Hi All,

 I have SER and mysql DB in USA and I am calling from India. For all 
 the calls I
 am dialling from India the time of call invite is getting recorded 
 5.5 hours
 ahead the local time in USA. Suppose if time in USA is 6:30 and if 
 I call from
 India, in mysql DB it is getting stored that I called at 12:00. So 
 for billing
 if I calculate calls between NOW() and NOW()-30 days, all the calls 
 in this 5.5
 hours are missing.
 Please tell me where I have to change my configuration. I have ser 
 -0.9.4 and
 Mysql 4.0 on Linux.

 Thanks for your help and time,
 Manoj.

 _______________________________________________
 Serusers mailing list
 serusers(a)lists.iptel.org
 http://lists.iptel.org/mailman/listinfo/serusers