Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CDR's timezone is different from IPPhone's and CallManager Server

Hi!

We installed a CUCMBE v6.0 , we put our local timezone (-5)in Date/Time Group , in the phones and server the time is ok , but the time in the cdr files appears with the UTC time. Can it be a bug? Thanks for any help.

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: CDR's timezone is different from IPPhone's and CallManager S

that is not a bug, that is the way it has always been. you get the time in UTC in the CDR records

if you use CAR it will compensate the time using the settings from the server, if you will use a 3rd party billing server it will have to take care of the conversion and adjustment to time zone

HTH

javalenc

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
2 REPLIES
Cisco Employee

Re: CDR's timezone is different from IPPhone's and CallManager S

that is not a bug, that is the way it has always been. you get the time in UTC in the CDR records

if you use CAR it will compensate the time using the settings from the server, if you will use a 3rd party billing server it will have to take care of the conversion and adjustment to time zone

HTH

javalenc

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
Hall of Fame Super Red

Re: CDR's timezone is different from IPPhone's and CallManager S

Hi Joel,

I beleive this is referred to as "Universal Time". Here is some related info;

Date Format in the CDR Database

In order to select all calls after a certain date, you need to convert the date you want into a value in universal time and in seconds since January 1st, 1970.

For example, 973995954 translates to 11/12/00 2:25 AM. Complete these steps in order to decipher the time stamp.

Go to Microsoft Excel.

In cell A1 type the number that is found in the last record for dateTimeOrigination.

In cell A2, paste the formula =A1/86400+DATE(1970,1,1).

Right-click on cell A2 and select format cells.

Under the Number tab select Time where the format is 3/14/98 130 PM.

The result is the actual time in readable format.

From this excellent doc;

Using SQL Queries to Search the Call Detail Record with Cisco CallManager

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml#understand

Hope this helps!

Rob

PS: I think these tools work as well :)

http://www.iwebtool.com/unix_time_converter

538
Views
0
Helpful
2
Replies
CreatePlease to create content