understanding the datetimeconnect # in the SQL CDR's
I am currently trying to export and make sence of the data in the SQL database when i look at the datetimeconnect field i recieve a 10 digit # is their some way of deciphering this #. This would really be helpful . Please let me know ..
Re: understanding the datetimeconnect # in the SQL CDR's
If I recall right it is number of seconds since Jan 1, 1980. Another developer might be able to provide more details, etc.
If they were using Win32 time values;
The Win32 time format is used by the Win32 APIs. The date and time is stored in a 64-bit value that represents the number of 100 nanoseconds since January 1st, 1601. This date was chosen because it is 400 years prior to the start of a new century. At 100ns resolution 32 bits is good for about 429 seconds (or 7 minutes) and a 63-bit integer is good for about 29,247 years.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...