Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Calendar Display with Language Specific Day/Month names Expand / Collapse
Author
Message
Posted Thursday, March 6, 2008 8:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 12:08 AM
Points: 211, Visits: 60
Comments posted to this topic are about the item Calendar Display with Language Specific Day/Month names
Post #465619
Posted Friday, April 25, 2008 1:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 6:50 AM
Points: 4, Visits: 94
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!
Post #490444
Posted Monday, April 28, 2008 12:34 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 28, 2012 7:01 AM
Points: 79, Visits: 1,207
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
Post #491651
Posted Tuesday, April 29, 2008 12:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 6:50 AM
Points: 4, Visits: 94
SELECT [alias] FROM [master].[dbo].[syslanguages]

Or you can use lcid if you modify the procedure slightly.
Post #491855
Posted Friday, May 9, 2008 4:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 7, 2009 12:23 AM
Points: 10, Visits: 24
excellent, thanks a lot.
Post #497717
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse