[cisco-voip] SQL Gurus - Need Help With CDR Command

[Stu Packett]

Thanks Wes.  That makes sense.

________________________________

From: Wes Sisk [mailto:wsisk at cisco.com] 
Sent: Tuesday, March 28, 2006 5:27 PM
Cc: Stu Packett; cisco-voip at puck-nether.net Voip
Subject: Re: [cisco-voip] SQL Gurus - Need Help With CDR Command


doh! 'dec 31, 1969' 


On Mar 28, 2006, at 8:24 PM, Wes Sisk wrote:

I usually modify the 'jan 1 1970 00:00:00' to compensate for offset. 

I am EST so I use 'dec 31, 1970 19:00:00'

otherwise you can wrap another dateadd around the one you are using.

/Wes

On Mar 28, 2006, at 4:37 PM, Stu Packett wrote:


I generally use the SQL query command below, but the time is not
correct.  It appears to be 8 hours off which is the same amount of hours
offset for Pacific time zone.  Does anyone know what I need to add to
have the query commands to reflect the -8:00 PST time zone?

select callingpartynumber, finalcalledpartynumber, datetimeorigination,
datetimedisconnect, duration, duration, DATEADD(ss, datetimeorigination,
'Jan 1, 1970 00:00:00')

from calldetailrecord 
where originalcalledpartynumber = '9911' 

Thanks. 



Disclaimer: If you have received this message in error, call (650)
988-8500 and delete or destroy any copy of this message.

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060330/56e81bc1/attachment.html