×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

How to change the timestamp in CDR from GMT to local time in Cisco CallManager 4.0

Document

Wed, 07/22/2009 - 19:58
Jun 22nd, 2009
User Badges:
  • Gold, 750 points or more

Resolution

The timestamps in Call Detail Record (CDR) are in UNIX time, which is the number of seconds since 1/1/1970 (midnight GMT).

For example, if you have a timestamp in an Excel spreadsheet in cell B1, you could use a formula like :DATE(1970,1,1)+B1/(60*60*24) to return the date portion, and a formula like :TIME(24-8,0,0)+B1/(60*60*24) to return the time portion. The "24-8" in the time function converts the tim ezone to GMT-8 (PST).

If you know the timestamp for a particular date, you can calulate the timestamp for another date by adding or subtracting 86400 (number of seconds in a day), multiplied by the number of days to get to the date you want. In Excel, if you have a date in cell A1 and a time in cell B1, you can use a formula like this:

=(A1-DATE(1970,1,1)+B1+TIME(24+8,0,0))*86400

to return the UNIX timestamp. The 24-8 in the Time function converts the time zone to GMT-8 (PST).

For more information, refer to the Timestamps section of Cisco CallManager Call Detail Record Definition for Release 3.3(2).

Loading.

Actions

This Document

Related Content