10-23-2002 01:31 PM - edited 03-12-2019 09:17 PM
I am trying to program a reporting tool for data from the CDR. However, I am having a hard time understanding the Date/Time data in the CDR, such as:
dateTimeOrigination
1020270700
1030564043
How do I understand these figures and put them into understandable Date/Time figures? I have read through the "Cisco CallManager Call Detail Record Definition" and it tells me what the definitions of each field, but not how to "transcribe" the coding (specifically for Time and Date).
Thanks!!
10-24-2002 12:14 AM
Hi,
I do not know if this helps, but in
http://www.cisco.com/warp/public/788/AVVID/ts_ccm_301_sec7.htm
says that:
"The value is a coordinated universal time (UTC) value and represents the number of seconds since Midnight (00:00:00) Jan. 1, 1970"
Yanna
10-24-2002 06:07 AM
If you have access to a unix system, you can use the shell 'date' command to do a quick conversion, e.g.:
(root@muon ~)3% date -r 1020270700
Wed May 1 17:31:40 BST 2002
In perl use the builtin localtime() functions, e.g.:
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst)
= localtime(1020270700);
print ("$hour:$min:$sec $mday/$mon/$year\n");
=> 17:31:40 1/4/102 (note that the year is an offset from 1900).
I don't see obvious ways in Excel to do the conversion, but maybe somebody else can help there.
John.
10-24-2002 10:12 AM
Thanks guys, but I actually was able to write something up myself. I am not using unix so I had to stick with Excel conversions. I was able to write a function and utilize the Excel decimal system for Date/Time. It works and it's accurate.
Thanks though for the responses!!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide