469,327 Members | 1,238 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,327 developers. It's quick & easy.

About calender week

13
Does anyone have any idea about calender week in SQL?
How can we count calender week from current date in SQL reporting?
Apr 21 '07 #1
1 1433
Expand|Select|Wrap|Line Numbers
  1. SELECT DATEPART(week, GETDATE()) AS 'Week Number'
  2. GO
Apr 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by LG | last post: by
4 posts views Thread by R. Beach | last post: by
4 posts views Thread by Chris | last post: by
7 posts views Thread by gubbachchi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.