[cisco-voip] CDR and custom reports

[Matthew Saskin]

CDR time is the number of seconds that have elapsed since Jan 1, 1970 - 
AKA epoch time.

Take the CDR timestamp divided by 86400 (number of seconds in a day).  
That gives you the number of days (plus fraction thereof) since day 0.  
Add that to Jan 1st, 1970 and you've got a real date/time.

If crystal has no ability to generate a timestamp natively, you could do 
the calculation all in the t-sql query using the dateadd function - 
generate a datetime variable that = 1/1/1970 00:00:00.000, use dateadd 
to increment "days" by (CDRSTAMP / 86400)

-matt

Robert Kulagowski wrote:
> Andrew F. Wolfe wrote:
>   
>> Hello all, this is a different kind of question for me.  If there are 
>> any Crystal Reports developers out there who have done any custom CDR 
>> reports, what type of formula did you use to convert the UNIX time to a 
>> readable time.  If anyone has this knowledge, I would love some help.  
>> Thanks. 
>>     
>
> In Excel, the formula to convert it would be: CDRTIME/86400+DATE(1970,1,1)
>
> Don't know anything about CR though.
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>