Understanding Date and Time Functions and Operations in SQL Server: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Understanding Date and Time Functions and Operations in SQL Server

page 6 of 8

by Abhishek Kumar Singh
Feedback

Average Rating:

Views (Total / Last 10 Days): 15173/ 276

Article Contents:

Using SET LANGUAGE command in SQL Server

By applying SET LANGUAGE command you can work with different language supported by Microsoft in the SQL Server. So this provides you a type of globalization feature in SQL Server.

Example:

Query

DECLARE @Today DATETIME
SET @Today = 'SEPTEMBER 23 2008'
 
SET LANGUAGE Italian
SELECT DATENAME(month, @Today) AS 'Month Name'
 
SET LANGUAGE us_english
SELECT DATENAME(month, @Today) AS 'Month Name' 
GO

The result window will be shown as follows:

Changed language setting to Italiano.
Month Name
------------------------------
settembre
 
(1 row(s) affected)
 
Changed language setting to us_english.
Month Name
------------------------------
September
 
(1 row(s) affected)

« (Page 5)

View Entire Article

(Page 7) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 8 and 5 and type the answer here:

User Comments

Title: awesome
Name: mahesh
Date: 5/29/2009 4:15:11 PM
Comment:
great job it helped me a lot thank you very much!!!!!!

Title: Great!!!
Name: Gourik Kumar Bora
Date: 3/31/2009 3:21:57 AM
Comment:
Hi,
Thanks a lot. quite a helpful article..

Title: set datefirst inside function
Name: ll
Date: 11/17/2008 7:24:10 AM
Comment:
how to use set datefirst inside function

Title: Thanks.
Name: Abhishek (Author)
Date: 11/13/2008 8:05:34 AM
Comment:
Thanks to all of you for appreaciating my article.

Title: Thanks a Lot
Name: Krishna Prabhu
Date: 11/13/2008 4:43:50 AM
Comment:
Thanks a lot for giving this artical.It helped in completing project

Title: Thnx a Ton
Name: Neha Mishra
Date: 11/12/2008 2:15:52 AM
Comment:
Thnx a ton for such a detailed and informatic article. It helped in clearing almost all my doubts.

Title: Thank you
Name: Vishal s.surana
Date: 11/11/2008 7:44:52 AM
Comment:
Thank you for your nice article.It is very helpful to understand differnt behaviour of datetime datatype.