Calendar Display with Language Specific Day/Month names

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by DASUN » Calendar Display with Language Specific...

Calendar Display with Language Specific Day/Month names

Rate Topic

Display Mode

Topic Options

Author

Message

darren.sunderland

Posted Thursday, March 06, 2008 8:51 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 7:27 AM
Points: 208, Visits: 49

Comments posted to this topic are about the item Calendar Display with Language Specific Day/Month names

Post #465619

Per Siden

Posted Friday, April 25, 2008 1:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 8:01 AM
Points: 4, Visits: 83

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

sqlemail@yahoo.com

Posted Monday, April 28, 2008 12:34 PM

SSC 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

Per Siden

Posted Tuesday, April 29, 2008 12:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 8:01 AM
Points: 4, Visits: 83

SELECT [alias] FROM [master].[dbo].[syslanguages]

Or you can use lcid if you modify the procedure slightly.

Post #491855

mayurs

Posted Friday, May 09, 2008 4:32 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, January 07, 2009 12:23 AM
Points: 10, Visits: 24

excellent, thanks a lot.

Post #497717

« Prev Topic | Next Topic »

Permissions