vegad Posted November 29, 2006 Share Posted November 29, 2006 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...... Link to comment Share on other sites More sharing options...
jesh Posted November 29, 2006 Share Posted November 29, 2006 If you are using SQL Server, you can use DATEPART.Something like this: SELECT * FROM MyTable WHERE DATEPART(dw, OperationDate) = 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now