Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange result using Week()
Message
De
24/08/2005 18:05:34
 
 
À
24/08/2005 16:48:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01043193
Message ID:
01043631
Vues:
12
>>>They both wrong and both right because they use there own definition of the WEEK(). See http://www.windowsitpro.com/SQLServer/Article/ArticleID/14340/14340.html, for example.
>>>
>>
>>I don't agree.
>
>You may not agree, but a standard is a standard, and the international standard is that week 1 is the first week of the year to contain at least four days.

This is incorrect because insufficient for a definition:
ISO-FDIS-8601.pdf

A calendar week is identified within a calendar year by the calendar week number.
This is its ordinal position within the year,
applying the rule that the first calendar week of a year
is the one that includes the first Thursday of that year
and
that the last calendar week of a calendar year is the week immediately
preceding the first calendar week of the next calendar year.


Without the second condition, the first is ambiguous.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform