[cisco-voip] Converting CCM Date/Time data to a readable formatusing SAS

[Joe Pollere (US)]

Excel formulas- enter known values in column A and these formulas in
column B:

To convert from cdr time 

=A3/86400+DATE(1970,1,1)

To convert to cdr time

=((A17)-((DATE(1970,1,1))))*86400

 

 I am not familiar with SAS but I suppose these would work.

To convert from SAS time 

=A3/86400+DATE(1960,1,1)

To convert to SAS time

=((A17)-((DATE(1960,1,1))))*86400

 

Joe

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of STEVEN CASPER
Sent: Tuesday, September 18, 2007 2:18 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Converting CCM Date/Time data to a readable
formatusing SAS

 

 Using SAS, I am trying to convert the dateTimeOrigination field in CDR
to a readable format from our  Cisco Call Manager Database. The data is
based on the number of seconds since standard epoch of 01.01.1970. The
starting point for SAS Date and Time Conversions is 01/01/1960.

 

I have submitted a request to SAS but  was wondering if any SAS user out
there might have an answer ?

 

Thanks

 

Richard Brown
Systems Technology
M&T Bank

************************************
This email may contain privileged and/or confidential information that
is intended solely for the use of the addressee. If you are not the
intended recipient or entity, you are strictly prohibited from
disclosing, copying, distributing or using any of the information
contained in the transmission. If you received this communication in
error, please contact the sender immediately and destroy the material in
its entirety, whether electronic or hard copy. This communication may
contain nonpublic personal information about consumers subject to the
restrictions of the Gramm-Leach-Bliley Act and the Sarbanes-Oxley Act.
You may not directly or indirectly reuse or disclose such information
for any purpose other than to provide the services for which you are
receiving the information.
There are risks associated with the use of electronic transmission. The
sender of this information does not control the method of transmittal or
service providers and assumes no duty or obligation for the security,
receipt, or third party interception of this transmission.
************************************




-----------------------------------------
Disclaimer:

This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the
designated addressee(s) named above only.  If you are not the
intended addressee, you are hereby notified that you have received
this communication in error and that any use or reproduction of
this email or its contents is strictly prohibited and may be
unlawful.  If you have received this communication in error, please
notify us immediately by replying to this message and deleting it
from your computer. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070919/6f854fb8/attachment.html