Click here to Skip to main content
15,064,166 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
I would like find the week of the date thro sql. The syntax is
Week('01/01/12') will give me the week of this date.
If iam executing this syntax, the week starts from sunday only but i would like to have starting of the week should be Saturday not sunday.
Can any one help me, how to write the sql for the starting week as saturday not sunday.
Posted

1 solution

You can use SET DATEFIRST to set it to the day you want. Check the link for more info.
http://msdn.microsoft.com/en-us/library/ms181598.aspx[^]

Good luck!
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900