Datepart question/oddity?

  • Why does this return 53? A year cannot have 53 weeks, I thought.

    select datepart(wk, '12/27/2010' )

    Thanks!

  • 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

  • Excellent, Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply