Ted Smith
SSC Veteran
Points: 255
More actions
February 13, 2007 at 2:59 pm
#175914
Why does this return 53? A year cannot have 53 weeks, I thought.
select datepart(wk, '12/27/2010' )
Thanks!
SQLBill
SSC Guru
Points: 51440
February 13, 2007 at 3:26 pm
#689597
the first week of 2010 is a two day week (Friday, Jan 1 and saturday, Jan 2). So, yes there are 53 weeks in 2010.
-SQLBill
February 13, 2007 at 3:33 pm
#689599
Excellent, Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply