sql查询显示星期至今 [英] sql query to display week to date
问题描述
我有2列,它们是日期,星期至今,我想要一年的数据如下格式。
日期名称WeekToDate
2008-01-01 00:00:00.000 2008-01-01 00:00:00.000
2008-01-02 00:00:00.000 2008 -01-01 00:00:00.000
2008-01-02 00:00:00.000 2008-01-02 00:00:00.000
2008-01-03 00:00:00.000 2008-01-01 00:00:00.000
2008-01-03 00:00:00.000 2008-01-02 00:00:00.000
2008-01-03 00:00:00.000 2008-01-03 00:00:00.000
2008-01-04 00:00:00.000 2008-01-01 00:00:00.000
2008-01-04 00:00:00.000 2008-01-02 00:00:00.000
2008-01-04 00:00:00.000 2008-01-03 00:00:00.000
2008-01-04 00:00:00.000 2008-01-04 00:00:00.000
2008-01-05 00:00: 00.000 2008-01-01 00:00:00.000
2008-01-05 00:00:00.000 2008-01-02 00:00:00.000
2008-01 -05 00:00:00.000 2008-01-03 00:00:00.000
2008-01-05 00:00:00.000 2008-01-04 00:00:00.000
2008-01-05 00:00:00.000 2008-01-05 00:00:00.000
2008-01-06 00:00:00.000 2008-01-01 00:00: 00.000
2008-01-06 00:00:00.000 2008-01-02 00:00:00.000
2008-01-06 00:00:00.000 2008-01 -03 00:00:00.000
2008-01-06 00:00:00.000 2008-01-04 00:00:00.000
2008-01-06 00: 00:00.000 2008-01-05 00:00:00.000
2008-01-06 00:00:00.000 2008-01-06 00:00:00.000
2008 -01-07 00:00:00.000 2008-01-07 00:00:00.000
2008-01-08 00:00:00.000 2008-01-07 00:00:00.000 >
2008-01-08 00:00:00.000 2008-01-08 00:00:00.000
2008-01-09 00:00:00.000 2008-01-07 00: 00:00.000
2008-01-09 00:00:00.000 2008-01-08 00:00:00.000
2008-01-09 00:00:00.000 2008 -01-09 00:00:00.000
2008-01-10 00:00:00.000 2008-01-07 00:00:00.000
2008-01-10 00:00:00.000 2008-01-08 00:00:00.000
2008-01-10 00:00:00.000 2008-01-09 00:00:00.000
2008-01-10 00:00:00.000 2008-01-10 00:00:00.000 >
2008-01-11 00:00:00.000 2008-01-07 00:00:00.000
2008-01-11 00:00:00.000 2008-01-08 00: 00:00.000
2008-01-11 00:00:00.000 2008-01-09 00:00:00.000
2008-01-11 00:00:00.000 2008 -01-10 00:00:00.000
2008-01-11 00:00:00.000 2008-01-11 00:00:00.000
2008-01-12 00:00:00.000 2008-01-07 00:00:00.000
2008-01-12 00:00:00.000 2008-01-08 00:00:00.000
2008-01-12 00:00:00.000 2008-01-09 00:00:00.000
2008-01-12 00:00:00.000 2008-01-10 00:00:00.000
2008-01-12 00:00:00.000 2008-01-11 00:00:00.000
2008-01-12 00:00:00.000 2008-01-12 00:00:00.000
2008-01-13 00:00:00.000 2008-01-07 00:00:00.000
2008-01-13 00:00: 00.000 2008-01-08 00:00:00.000
2008-01-13 00:00:00.000 2008-01-09 00:00:00.000
2008-01 -13 00:00:00.000 2008-01-10 00:00:00.000
2008-01-13 00:00:00.000 2008-01-11 00:00:00.000
2008-01-13 00:00:00.000 2008-01-12 00:00:00.000
2008-01-13 00:00:00.000 2008-01-13 00:00:00.000
2008-01-14 00:00:00.000 2008-01-14 00:00:00.000
。
。
。
。
。
。
。
。
。
2008-01-27 00 :00:00.000 2008-01-24 00:00:00.000
2008-01-27 00:00:00.000 2008-01-25 00:00:00.000
2008-01-27 00:00:00.000 2008-01-26 00:00:00.000
2008-01-27 00:00:00.000 2008-01-27 00:00:00.000
2008-01-28 00:00:00.000 2008-01-28 00:00:00.000
2008-01-29 00:00:00.000 2008-01-28 00 :00:00.000
2008-01-29 00:00:00.000 2008-01-29 00:00:00.000
2008-01-30 00:00:00.000 2008-01-28 00:00:00.000
2008-01-30 00:00:00.000 2008-01-29 00:00:00.000
2008-01- 30 00:00:00.000 2008-01-30 00:00:00.000
2008-01-31 00:00:00.000 2008-01-28 00:00:00.000
2008-01-31 00:00:00.000 2008-01-29 00:00:00.000
2008-01-31 00:00:00.000 2008-01-30 00:00:00.000
2008-01-31 00:00:00.000 2008-01-31 00:00:00.000
谢谢
您可以使用YEAR函数和/或使用BETWEEN运算符,例如:
选择 * < span class =code-keyword> from TableName 其中年(WeekToDate)= 2008
Hi,
I have 2 columns they are date, week to date, i want one year data like below format.
Date Name WeekToDate
2008-01-01 00:00:00.000 2008-01-01 00:00:00.000
2008-01-02 00:00:00.000 2008-01-01 00:00:00.000
2008-01-02 00:00:00.000 2008-01-02 00:00:00.000
2008-01-03 00:00:00.000 2008-01-01 00:00:00.000
2008-01-03 00:00:00.000 2008-01-02 00:00:00.000
2008-01-03 00:00:00.000 2008-01-03 00:00:00.000
2008-01-04 00:00:00.000 2008-01-01 00:00:00.000
2008-01-04 00:00:00.000 2008-01-02 00:00:00.000
2008-01-04 00:00:00.000 2008-01-03 00:00:00.000
2008-01-04 00:00:00.000 2008-01-04 00:00:00.000
2008-01-05 00:00:00.000 2008-01-01 00:00:00.000
2008-01-05 00:00:00.000 2008-01-02 00:00:00.000
2008-01-05 00:00:00.000 2008-01-03 00:00:00.000
2008-01-05 00:00:00.000 2008-01-04 00:00:00.000
2008-01-05 00:00:00.000 2008-01-05 00:00:00.000
2008-01-06 00:00:00.000 2008-01-01 00:00:00.000
2008-01-06 00:00:00.000 2008-01-02 00:00:00.000
2008-01-06 00:00:00.000 2008-01-03 00:00:00.000
2008-01-06 00:00:00.000 2008-01-04 00:00:00.000
2008-01-06 00:00:00.000 2008-01-05 00:00:00.000
2008-01-06 00:00:00.000 2008-01-06 00:00:00.000
2008-01-07 00:00:00.000 2008-01-07 00:00:00.000
2008-01-08 00:00:00.000 2008-01-07 00:00:00.000
2008-01-08 00:00:00.000 2008-01-08 00:00:00.000
2008-01-09 00:00:00.000 2008-01-07 00:00:00.000
2008-01-09 00:00:00.000 2008-01-08 00:00:00.000
2008-01-09 00:00:00.000 2008-01-09 00:00:00.000
2008-01-10 00:00:00.000 2008-01-07 00:00:00.000
2008-01-10 00:00:00.000 2008-01-08 00:00:00.000
2008-01-10 00:00:00.000 2008-01-09 00:00:00.000
2008-01-10 00:00:00.000 2008-01-10 00:00:00.000
2008-01-11 00:00:00.000 2008-01-07 00:00:00.000
2008-01-11 00:00:00.000 2008-01-08 00:00:00.000
2008-01-11 00:00:00.000 2008-01-09 00:00:00.000
2008-01-11 00:00:00.000 2008-01-10 00:00:00.000
2008-01-11 00:00:00.000 2008-01-11 00:00:00.000
2008-01-12 00:00:00.000 2008-01-07 00:00:00.000
2008-01-12 00:00:00.000 2008-01-08 00:00:00.000
2008-01-12 00:00:00.000 2008-01-09 00:00:00.000
2008-01-12 00:00:00.000 2008-01-10 00:00:00.000
2008-01-12 00:00:00.000 2008-01-11 00:00:00.000
2008-01-12 00:00:00.000 2008-01-12 00:00:00.000
2008-01-13 00:00:00.000 2008-01-07 00:00:00.000
2008-01-13 00:00:00.000 2008-01-08 00:00:00.000
2008-01-13 00:00:00.000 2008-01-09 00:00:00.000
2008-01-13 00:00:00.000 2008-01-10 00:00:00.000
2008-01-13 00:00:00.000 2008-01-11 00:00:00.000
2008-01-13 00:00:00.000 2008-01-12 00:00:00.000
2008-01-13 00:00:00.000 2008-01-13 00:00:00.000
2008-01-14 00:00:00.000 2008-01-14 00:00:00.000
.
.
.
.
.
.
.
.
.
2008-01-27 00:00:00.000 2008-01-24 00:00:00.000
2008-01-27 00:00:00.000 2008-01-25 00:00:00.000
2008-01-27 00:00:00.000 2008-01-26 00:00:00.000
2008-01-27 00:00:00.000 2008-01-27 00:00:00.000
2008-01-28 00:00:00.000 2008-01-28 00:00:00.000
2008-01-29 00:00:00.000 2008-01-28 00:00:00.000
2008-01-29 00:00:00.000 2008-01-29 00:00:00.000
2008-01-30 00:00:00.000 2008-01-28 00:00:00.000
2008-01-30 00:00:00.000 2008-01-29 00:00:00.000
2008-01-30 00:00:00.000 2008-01-30 00:00:00.000
2008-01-31 00:00:00.000 2008-01-28 00:00:00.000
2008-01-31 00:00:00.000 2008-01-29 00:00:00.000
2008-01-31 00:00:00.000 2008-01-30 00:00:00.000
2008-01-31 00:00:00.000 2008-01-31 00:00:00.000
Thanks
You can use YEAR function and/or use BETWEEN operator eg:
select * from TableName where YEAR(WeekToDate) = 2008
这篇关于sql查询显示星期至今的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!