<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2838" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; khtml-nbsp-mode: space; khtml-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=603534117-30032006><FONT face=Tahoma
color=#0000ff size=2>Thanks Wes. That makes sense.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Wes Sisk [mailto:wsisk@cisco.com]
<BR><B>Sent:</B> Tuesday, March 28, 2006 5:27 PM<BR><B>Cc:</B> Stu Packett;
cisco-voip@puck-nether.net Voip<BR><B>Subject:</B> Re: [cisco-voip] SQL Gurus -
Need Help With CDR Command<BR></FONT><BR></DIV>
<DIV></DIV>doh! 'dec 31, 1969'
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV><BR>
<DIV>
<DIV>On Mar 28, 2006, at 8:24 PM, Wes Sisk wrote:</DIV><BR
class=Apple-interchange-newline>I usually modify the 'jan 1 1970 00:00:00' to
compensate for offset.
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>I am EST so I use 'dec 31, 1970 19:00:00'</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>otherwise you can wrap another dateadd around the one you are using.</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>/Wes</DIV>
<DIV><BR>
<DIV>
<DIV>On Mar 28, 2006, at 4:37 PM, Stu Packett wrote:</DIV><BR
class=Apple-interchange-newline>
<P><FONT face=Tahoma size=2>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?</FONT></P>
<P><FONT face=Tahoma size=2>select callingpartynumber, finalcalledpartynumber,
datetimeorigination, datetimedisconnect, duration, duration, DATEADD(ss,
datetimeorigination, 'Jan 1, 1970 00:00:00')</FONT></P>
<P><FONT face=Tahoma size=2>from calldetailrecord</FONT> <BR><FONT face=Tahoma
size=2>where originalcalledpartynumber = '9911'</FONT> </P>
<P><FONT face=Tahoma size=2>Thanks.</FONT> </P><BR><BR>
<P><FONT face=Tahoma color=#c0c0c0 size=1>Disclaimer: If you have received this
message in error, call (650) 988-8500 and delete or destroy any copy of this
message.</FONT></P>
<DIV style="MARGIN: 0px">_______________________________________________</DIV>
<DIV style="MARGIN: 0px">cisco-voip mailing list</DIV>
<DIV style="MARGIN: 0px"><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A></DIV>
<DIV style="MARGIN: 0px"><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A></DIV></DIV><BR></DIV>
<DIV style="MARGIN: 0px">_______________________________________________</DIV>
<DIV style="MARGIN: 0px">cisco-voip mailing list</DIV>
<DIV style="MARGIN: 0px"><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A></DIV>
<DIV style="MARGIN: 0px"><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A></DIV></DIV><BR></DIV></BODY></HTML>