Technical Article

Output Language Date Settings

,

Display language/date settings for your SQL Server.

drop procedure hx_ServerLangReference
go

create procedure hx_ServerLangReference
as

/* Robert Vallee 09/03/2001
rvallee@hybridx.com
input: none
output: table format
description: Simple display of language/date settings for your SQL Server

*/
select L.name, L.alias, L.months, L.shortmonths, L.days, L.dateformat, 
'First day of the week' = case
when L.datefirst = 1 then 'Monday'
when L.datefirst = 2 then 'Tuesday'
when L.datefirst = 3 then 'Wedsenday'
when L.datefirst = 4 then 'Thursday'
when L.datefirst = 5 then 'Friday'
when L.datefirst = 6 then 'Saturday'
when L.datefirst = 7 then 'Sunday'
end
from master.dbo.syslanguages L 
where 1 = 1

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating