Home > Uncategorized > Strange Day For Sql Server DatePart Function.

Strange Day For Sql Server DatePart Function.


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.

Advertisements
Categories: Uncategorized
  1. December 31, 2012 at 12:09 PM

    It will happen again
    31/12/2040 and 31/12/2068 🙂

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: