Stack Exchange
log in help

Eight days a week

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @ date='2100-12-31'

SELECT
year(z|7^1),(datepart(y,z|7^1)+7)/8,z%8FROM(SELECT
datediff(d,2,@)z)t
fork query

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results