|
Home > Archive > Voice over IP Cisco > March 2007 > CDR and custom reports
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
CDR and custom reports
|
|
| Andrew F. Wolfe 2007-03-29, 7:11 pm |
| 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.
| |
| Robert Kulagowski 2007-03-29, 7:11 pm |
| 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.
| |
| Matthew Saskin 2007-03-29, 7:11 pm |
| 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:
>
>
> 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@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
| |
| Chris Beck - CEC 2007-03-29, 7:11 pm |
| Don't forget to adjust for timezone. The formula below will only get
you to GMT
-----Original Message-----
From: Robert Kulagowski [mailto:bob@smalltime.com]
Sent: Thursday, March 29, 2007 2:55 PM
To: Andrew F. Wolfe
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR and custom reports
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.
|
|
|
|
|