Hi cisco used to provide an unsupported utility with call manager to convert date formats in data dump files from sql query's. Can anybody provide me the link for that? I can't find it anywhere and all of the web based converters always have wrong dates.
Here is some related info (I don't remember ever seeing an actual Utility);
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
Hope this helps!