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

[Stu Packett]

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060328/14e181b3/attachment.html