i want to now from all of u if u know

[vegad]

helloevery onei have one problem with retrive data from table.....my qus. is how to retrive only sunday form a particuler time period of year 2004 and 2005.i have a qus like that....---- For the period 2004-2005 find the number of operation carried out on a sunday.its very urgent i want ans before friday if it is posible.if any body know about that plz send me e- mail my e-mail id is vegad_dk@yahoo.co.inthank u i m waiting for ur your valueable reply......

[jesh]

If you are using SQL Server, you can use DATEPART.Something like this:

SELECT * FROM MyTable WHERE DATEPART(dw, OperationDate) = 1