<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">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 size="2" face="Tahoma">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 size="2" face="Tahoma">select callingpartynumber, finalcalledpartynumber, datetimeorigination, datetimedisconnect, duration, duration, DATEADD(ss, datetimeorigination, 'Jan 1, 1970 00:00:00')</FONT></P><P><FONT size="2" face="Tahoma">from calldetailrecord</FONT> <BR><FONT size="2" face="Tahoma">where originalcalledpartynumber = '9911'</FONT> </P><P><FONT size="2" face="Tahoma">Thanks.</FONT> </P> <BR> <BR><P><FONT color="#C0C0C0" size="1" face="Tahoma">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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">cisco-voip mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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>