March 6, 2008 at 8:51 pm
Comments posted to this topic are about the item Calendar Display with Language Specific Day/Month names
April 25, 2008 at 1:38 am
Very nice indeed, except maybe that the week numbers are incorrect, or at least does not comply with the internationell standard ISO 8601 (1972). For example, the year 2006 week number 1 starts om monday january 2, not on monday december 26 as claimed by this procedure (that week is actually week number 52 of 2005).
According to the internationell standard ISO 8601 (1972) the first day of week is Monday,
and weeks are numbered from 1 to 52 or in some cases from 1 to 53.
Week number 1 is the first week of the year (either expression is true, only need to check one)
- containing january 4
- containing at least 4 days
- containing a thursday
With a fix for the week number, this procedure would be really handy. Good work!
April 28, 2008 at 12:34 pm
1. Can you please provide few more sample of the 2nd parameter value; currently you mentioned the value as "English", what other values are supported
2. Where can we get a consolidated list of the value for 2nd parameter
paul
April 29, 2008 at 12:38 am
SELECT [alias] FROM [master].[dbo].[syslanguages]
Or you can use lcid if you modify the procedure slightly.
May 9, 2008 at 4:32 am
excellent, thanks a lot.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply