The equivalent SQL Server function is datepart, passing as parameters the date part you want, in this case weekday as &#39;dw&#39; and the actual date<br><br><div class="gmail_quote">On Mon, Aug 16, 2010 at 4:54 PM, Chris | Ronell Africa <span dir="ltr">&lt;<a href="mailto:chris@ronellafrica.com">chris@ronellafrica.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">








<div lang="EN-GB" link="blue" vlink="purple">

<div>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Dont know about mssql but in mysql there is a function like
dayofweek</span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">So select becomes</span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Select xxxxxx from abcd where x=y and y=z and dayofweek(datecolumn)
not in (6,7)</span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>

<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">

<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt">From:</span></b><span lang="EN-US" style="font-size:10.0pt"> Calvin Omari
[mailto:<a href="mailto:calvinebarongo@gmail.com" target="_blank">calvinebarongo@gmail.com</a>] <br>
<b>Sent:</b> 16 August 2010 1:58 p<br>
<b>To:</b> Skunkworks Forum<br>
<b>Subject:</b> [Skunkworks] MSSQL - getting time different excluding weekends</span></p>

</div><div><div></div><div class="h5">

<p class="MsoNormal"> </p>

<p class="MsoNormal"><br clear="all">
Hi,<br>
I am doing an ms sql select but i want to exclude week ends as i want am doing
a different bewteen when a product was sold and when payment was done I need
the diffrent between the sold date and paid date excluding weekends<br>
<br>
Any idea is highly appreciated<br>
<br>
Regards<br>
-- <br>
Our greatest fear is not that we are inadequate,<br>
but that we are powerful beyond measure.<br>
It is our light, not our darkness, that frightens us.<br>
<br>
Calvin Omari Systems Developer/Designer<br>
<a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> </p>

</div></div></div>

</div>


<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>

------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>