Archive for December, 2012

Strange Day For Sql Server DatePart Function.

December 31, 2012 1 comment

Today is Strange Date for SqlServer 31/12/2012. This is the only day

SELECT datepart(WEEK,’31/12/2012′) Shows 54! (If your first day is Monday)

It will not show 54 for along time.

When it will show 54 again? 

1.This fist day of year must be Sunday.

2.February must show 29. Year has to be leap year.

Happy new year.

Categories: Uncategorized