如何将一年开始日期的周数记录到某个日期 [英] How to get week number for a year start date to some date

问题描述

如何获取一年开始日期到某个日期的周数？

或

如何在几周内分割日期如下？



示例

i需要像这样

How to get week number for a year start date to some date?
or
how to split dates in weeks like below?

Example
i need like this

1 week 1    01-01-2013 to 01-07-2013
2 week 2    01-08-2013 to 01-16-2013
3 week 3    01-17-2013 to 01-23-2013
4 week 4    01-24-2013 to 01-30-2013
5 week 5    01-31-2013 to 01-06-2013

不喜欢以下

1   Week-1  2012-12-30 00:00:00.000    2013-01-05 00:00:00.000
2   Week-2  2013-01-06 00:00:00.000    2013-01-12 00:00:00.000
3   Week-3  2013-01-13 00:00:00.000    2013-01-19 00:00:00.000
4   Week-4  2013-01-20 00:00:00.000    2013-01-26 00:00:00.000
5   Week-5  2013-01-27 00:00:00.000    2013-02-02 00:00:00.000

如何获得此日期？

how to get this dates?

推荐答案

使用DatePart函数获取周数。请查看以下代码。

Use DatePart Function to Get Week Number. Look at following code.

select (ww,'1-Jan-2013')

查询获取表中的周数

Query for getting weeknumber in table

select Column1,datepart(ww,Column2) from TableName

您是否看过datediff函数，它应该可以计算2个日期之间的周数

Hi have you looked at the datediff function which should be able to count the number of weeks between 2 dates

这篇关于如何将一年开始日期的周数记录到某个日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！