<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>SQL Gurus - Need Help With CDR Command</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<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>
</BODY>
</HTML>