[SR-Users] Question about time display in SIREMIS 2.0

[Ricardo Martinez]

Hello Ramona.

It is odd.  I have created a table in my openser database called
“statistics”.  The time_stamp column stores the $Ts from Kamailio.

These are my last three entries :



mysql> select id,time_stamp,ul_users,fwd_requests from statistics ORDER by
id DESC limit 3;

+------+------------+----------+--------------+

| id   | time_stamp | ul_users | fwd_requests |

+------+------------+----------+--------------+

| 2002 | 1299098096 |        1 |            0 |

| 2001 | 1299097646 |        1 |           18 |

| 2000 | 1299097346 |        1 |           18 |

+------+------------+----------+--------------+

3 rows in set (0.00 sec)



If I convert the last three timestamps I get :



1299098096 à Wed, 02 Mar 2011 20:22:26 GMT

1299097646 à Wed, 02 Mar 2011 20:27:26 GMT

1299098096 à Wed, 02 Mar 2011 20:34:56 GMT



But in the charts I keeps seeing the last entry as : 12:34:56 PM.







My time_stamp column is created as INT().  Could that be the problem?



+--------------------+---------+------+-----+---------+----------------+

| Field              | Type    | Null | Key | Default | Extra          |

+--------------------+---------+------+-----+---------+----------------+

| id                 | int(11) | NO   | PRI | NULL    | auto_increment |

| time_stamp         | int(11) | YES  |     | NULL    |                |

+--------------------+---------+------+-----+---------+----------------+



Hope you can help me.

Thanks in advance,

Regards,



Ricardo Martinez.-





*De:* Elena-Ramona Modroiu [mailto:ramona at asipto.com]
*Enviado el:* miércoles, 02 de marzo de 2011 15:48
*Para:* Ricardo Martinez
*CC:* sr-users at lists.sip-router.org
*Asunto:* Re: [SR-Users] Question about time display in SIREMIS 2.0



Hi,

for charts siremis uses the date() function to convert from unix timestamp
that is written by kamailio to the displayed date. It might be possible to
adjust the timezone from php.ini.

Regards,
Ramona

On 2/28/11 10:30 PM, Ricardo Martinez wrote:

Hello.

Is there a way to adjust the timezone to display the charts and the logs in
the SIREMIS 2.0?  I have my linux machine with my local timezone, but the
display in the charts and the logs are not in synch with my local time.

Thanks in advance.



Regards,



Ricardo Martinez.-







_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users at lists.sip-router.org

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110302/22c393ad/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12621 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110302/22c393ad/attachment-0001.png>