News Networks
Topics
Stories
People

  • My Networks
  • Popular
  • Recent
  • ABC...XYZ
  • Create New
  • Search
  • Popular
  • Recent
  • Rising Fast
  • ABC...XYZ
  • Popular Today
  • Popular Week
  • Popular Month
  • Rising Fast
  • Hot Discussions
  • My Newsmakers
  • My Followers
  • Recently Active
  • Popular
  • Find
  • Invite Friends
Connect
Sign in using facebook |
Log in |
Sign Up


Hi there. I'm Jason, one of the founders of socialmedian.
socialmedian delivers the news, filtered by your network.
We'd love to have you join in.
You can use facebook connect to sign in.
Connect
OR
Log in 
|
Sign up


Create your socialmedian account
Email
Required

Password
Required

The password must be atleast 6 characters
Username
Required

http://www.socialmedian.com/username
This is same as my twitter ID
Security check

I agree to the terms and conditions and the privacy policy.
Loading...


Already a user? Please Log In
Invalid Login!
Email

Password

Remember me:
Loading...


Forgot Password?

Email:

By
Add News Flash
User-submitted headlines for this story

Loading

1
Clip
ISO Week In SQL Server
Source: Data Management
Sep 22, 2008


Dislike
 
0%
 
0%

Like

Summary
ISO Week in SQL Server

First let’s take a look at what ISO week is, from WikiPedia:

Week date representations are in the format as shown below.

YYYY-Www or YYYYWww

YYYY-Www-D or YYYYWwwD



[YYYY] indicates the so-called ISO year which is slightly different than the calendar year (see below). [Www] is the week number prefixed by the letter ‘W’, from W01 through W53. [D] is the weekday number, from 1 through 7, beginning with Monday and ending with Sunday. This form is popular in the manufacturing industries.

There are mutually equivalent definitions for week 01:




  • the week with the year’s first Thursday in it,

  • the week with 4 January in it,

  • the first week with the majority (four or more) of its days in the starting year, and

  • the week starting with the Monday in the period 29 December – 4 January.



If 1 January is on a Monday, Tuesday, Wednesday or Thursday, it is in week 01. If 1 January is on a Friday, Saturday or Sunday, it is in week 52 or 53 of the previous year.

The week number can be described by counting the Thursdays: week 12 contains the 12th Thursday

...Read the full article

Comments (0)
Add Your Comment
Please enter your Email Id to get a new password
Forgot your password?
Email:

Add something

Snip
News
Site

Instantly Clip News From Any Website
Clip it! on s|m
Or, Enter News Directly Here
Headline:

URL:
(Optional)

Description:
(Optional)

Adding a News...


Add Snip
Adding a Snip...


Now you can import your favorite sites to your socialmedian page
Loading...

Loading...


Is this you?
Stats

Mood
0% Like

0% Dislike

1 Clip

Loading...

Denis Gobo

Share this story

Network
Email
Tweet
Share with the News Network
Email ID's
(multiple Email ID's separated by commas)
Message
Also post this message as a public comment
Don't worry. We won't share the name or email address of the person that you sent the story to.
Loading...

Message
119

bit.ly (short) url will be added to the message.
Link to discuss this story on socialmedian

Link to the original story

Twitter ID

Password

Save my twitter password
Tweet will be sent using   (change)
Topics

SQL Server
Add Topics

Comma Separated.
Belongs to News Networks

SQL Server (Users: 6)
Stories in 24 hours: 0
Register using your Twitter ID and we'll help you easily connect
your accounts and find people you already know.

We constantly make updates and enhancements based on user feedback. Follow socialmedian on Twitter
Help us out and report a bug or suggest a new feature! Check out our blog for regular company updates, notables, and to see what we're currently working on.
Report a Bug
Suggest a Feature


 Sending...
close
socialmedian Inc. 2008 - 2009
About socialmedian    |        |    Terms of Service    |    Privacy Policy