如何在Sql中获取给定月份和年份的周数 [英] How Can I Get Week Number For Given Month And Year In Sql

问题描述

嗨

我必须知道如何获得给定月份和年份的周数



我有一个输入为月，年份



第二是我需要获得特定周数的周开始日期




如果你可以帮我这个

解决方案

你的问题不清楚，无论它是什么，你应该能够工作将是非常有帮助的参考这些解决方案：

1. 如何到获得周数的最 - 月 - 来自该日期在-SQL服务器 [<一个href =http://stackoverflow.com/questions/13116222/get-week-number-of-the-month-from-the-date-in-sql-server-2008\"target =_ blanktitle =New窗口> ^ ]

2. 获得-T他周开始日期和周末日期 - 从周数字编号 [ ^ ]

试试这个



选择DatePart（周，'2012/11/30'）// **返回48 **

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

解决方案

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[^]

Try this

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

这篇关于如何在Sql中获取给定月份和年份的周数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！