stored procedure datetime question.

[TomPhillips]

In a stored procedure, if I declare @myDate DateTime
and
set @myDate = '7/4/2005'

How do I determine if @myDate is a Tuesday?

or

How do I find out what DayOfWeek it is?

This is easy in VB.NET but I can't see how to do it in an sp.

In MSSQL, btw.

 

[PelleH]

Hi,

Check out the DATEPART function in sql server books online.

/Pelle

 

[TomPhillips]

DATEPART v. DATENAME

I used
if DATENAME(weekday, @myDate) = 'Tuesday' then ...

I wonder if
if DATEPART(day, @myDate) = 3 then ...
is more efficient (assuming Tuesday = 3)?