How Can I Get Week Number For Given Month And Year In Sql

Question

0.00/5 (No votes)

See more:

Hi
I have to know how to get week number in a given month and year

I have a inputs as Month,Year

Second is i need to get week starting date for that particular week number

It will be very helpful if you could help me on this

Posted 1-Jul-14 1:39am

sushma_bhardwaj

Add a Solution

Comments

[no name] 1-Jul-14 7:40am

http://www.google.com/search?q=sql+get+week+number

sushma_bhardwaj 1-Jul-14 7:47am

Hithe url shows current date weeknumber. but I have input as month number ,week number for tht month and year. i don have paerticular date.

[no name] 1-Jul-14 13:45pm

And so? I don't see how that could possibly be a problem when you have not made any effort at all to solve your own problem.

Kornfeld Eliyahu Peter 1-Jul-14 7:40am

In a month there are more than one weeks!?

OriginalGriff 1-Jul-14 7:47am

Oh gawd yes...week number is a PITA: week one is the first week that contains a Thursday in the new year. So the 1st of January can be in week one, or in the last week of the previous year. Which could be Week 51, 52, or 53, depending on when Jan 1st of *that* year fell...
And don't forget that there may be a Feb 29th stuck in the middle which means it isn't as simple as it could be :laugh:

Fortunately, it's all worked out for you these days!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Peter Leow · Answer 1 · 2014-07-01T01:46:00

Solution 1

Your question is not clear, whatever it is, you should be able to work out your solution by referring to these:
1. how-to-get-week-number-of-the-month-from-the-date-in-sql-server[^]
2. get-the-week-start-date-and-week-end-date-from-week-number-in-sql[^]

Posted 1-Jul-14 1:46am

Peter Leow

Updated 1-Jul-14 1:47am

v2

Comments

sushma_bhardwaj 1-Jul-14 7:54am

Hi
thanks for the urls. can we get week number by using month number and year???
example. i have month number as 6 (june) year (2014) for june week number is 23 that means first week number. can we do that .. help me please,

sasidharraju · Answer 2 · 2014-07-01T01:47:00

Solution 2

Try this

Select DatePart(week, '2012/11/30') // **returns 48**

Posted 1-Jul-14 1:47am

sasidharraju

Comments

sushma_bhardwaj 1-Jul-14 7:55am

HiI tried this. this is shows correct . but instead of giving date (2014/11/30), is there any logic to get week number from month number and year.

sasidharraju 1-Jul-14 8:08am

just u check this url may be it's useful
http://www.lifeaftercoffee.com/2006/02/01/sql-find-the-week-number-in-a-month/

sasidharraju 1-Jul-14 8:10am

check one more url

http://scn.sap.com/thread/1951103

sushma_bhardwaj 1-Jul-14 8:26am

Thank you
but the TRUNC key word is not supporting inmy DB SQL 2008 :(